select range next to activecell
 

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) ?

select range next to activecell
 

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) ?

select range next to activecell
 

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" 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) ?

select range next to activecell
 

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