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?

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"lookin" wrote in message
oups.com...
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) ?