select range next to activecell

[lookin]

I need to select a range of cells next to an active cell. My
activecell is named "EmptyCell", but the RC coordinates may change, so
I can't refer to the active cell's RC values. How do I select the
range starting at ActiveCell.offset(0,1) to ActiveCell.offset(10, 3) ?

 

[Zack Barresse]

Hi there lookin,

Range(ActiveCell.offset(0,1), ActiveCell.offset(10, 3)).Select

Although there is generally little need to actually Select/Activate anything
whilst using VBA. Is there something you are trying to accomplish with this
particular range? I think you've probably got some code already which you
are using and this is probably part of a bigger solution. Can you post your
code?

 

[Chip Pearson]

Try

Range(ActiveCell.Offset(0, 1), ActiveCell.Offset(10, 3)).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[lookin]

Thanks guys! I could swear I tried that, but I must have typed
something wrong - it's working now!