Inserting Name in a cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ramesh - 26 May 2008 08:45 GMT

Hi all, Good Morning

Please let me know the code mistake in- following and request to
rectify the same.

Sub Ramaa()
Cells = InputBox("Enter NAME")
Worksheets("Sheet1").Cells (", , 1") & " .Visible = Flase"
End Sub

thanks in advance

ramesh

Reply to this Message

Stefi - 26 May 2008 08:58 GMT

Worksheets("Sheet1").Cells (", , 1") & " .Visible = Flase"
Cells () must have two numeric arguments (rowNo,colNo), e.g. Cells(1,1) or
Cells(2,1), etc.
Flase is wrong, correct to False

Regards,
Stefi

„ramesh” ezt írta:

> Hi all, Good Morning
>
[quoted text clipped - 11 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message

Per Jessen - 26 May 2008 08:58 GMT

Hi

I'm not sure what you are trying do do, but if you want to input a name and
put it in A1, then try this.

Sub Ramaa()
Name = InputBox("Enter NAME")
Worksheets("Sheet1").Cells(1, 1) = Name
End Sub

If this isn't what you want to do, please describe in words, what you want
to do.

Regards,
Per

> Hi all, Good Morning
>
[quoted text clipped - 11 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message

ramesh - 26 May 2008 10:09 GMT

Hi all

While entering name in input box , in sheet 1 all 60000+
rows the name has appeared in all rows with a run time error 438
(Object does not support this method). How the name has appeared in all
rows?

thanks in advance for yr suggestions.

ramesh

Reply to this Message

Stefi - 26 May 2008 10:17 GMT

Cells represents ALL cells in the sheet. You have to refer to one cell like
Cells(roNo,colNo)!
Stefi

„ramesh” ezt írta:

> Hi all
>
[quoted text clipped - 8 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message