MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Syntax for using variables in a range


Posted by Bill Mahoney on February 14, 2002 6:55 AM

Hello, i am trying to copy a range of cells to the cells beneath it and then do the same down to the last row but i can't seem to get the syntax for it. i know to select one cell using a variable is:

Range("a" & i).Select
but
Range("a" & i:"d" & i).Select doesn't

if somenone could correct my ignorance i would be most thankful.

Regards,
Bill Mahoney
New York, NY


Posted by JohnG on February 14, 2002 7:00 AM

try

Range("a" & i & ":d" & i).Select

Posted by Bill Mahoney on February 14, 2002 7:09 AM

Thanks for the help.