VBA Excel 2000 - Range selection with Cells

Dear Experts,

I am searching an alternative for this simple row in VBA so selecting a certain range

Range("A11:G18").Select

Could be done somehow this with applying Cells?

So for example the Cells(11, 1).Select selects the A11, but could be such applied to selecting an area until Cells(11,7) ?

thanks,
LVL 1
csehzIT consultantAsked:
Who is Participating?
 
jo_mConnect With a Mentor Commented:

hello there

 if you are  starting at A1  then you could use

Range("A1").offset(11,7).select

 this will select all from the start cell Address to your final cell address


 I hope this is what you are looking for

tx

jo
0
 
csehzIT consultantAuthor Commented:
Jo thanks yes you are right, I could do it with offset.

Basically I would like to put variable like offset(11," & Something & ").
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.