Inserting Name in a cells

R

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

*** Sent via Developersdex http://www.developersdex.com ***
 
S

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:
 
P

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
 
R

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

*** Sent via Developersdex http://www.developersdex.com ***
 
S

Stefi

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


„ramesh†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top