Inserting Name in a cells

[ramesh]

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

 

[Stefi]

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:

 

[Per Jessen]

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

 

[ramesh]

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

 

[Stefi]

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


„ramesh†ezt írta: