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

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" <[email protected]> wrote in message
news:[email protected]...
>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) ?
>

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" <[email protected]> wrote in message
news:[email protected]...
>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) ?
>

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