• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

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,
0
csehz
Asked:
csehz
1 Solution
 
jo_mCommented:

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
 
csehzAuthor 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now