MrExcel Publishing
Your One Stop for Excel Tips & Solutions

help with selecting cell groups with variable

Posted by jason on November 26, 2001 1:52 PM


I am having trouble with a line of code. What I want to do is to select cells ax:dx where x is my variable.
to select one cell I use range("a" & x).select, but how do I select more than one cell? I tried ("a" & x:"d" & x) to no avail. Can someone help me out.


Posted by Juan Pablo on November 26, 2001 1:53 PM

You were very close, the ":" is also text...

Range("A" & x & ":D" & x).Select

Juan Pablo

Posted by jason on November 26, 2001 2:09 PM

Thanks for the help (NT)

Thanks for the help