Select
 

I need a simple VBA to select the following range: the active cell and the
next to cells to the right. I want this to be relative to where ever the
active cell is. So I want it to select the active cell and the range to the
offset (0,2)


--
Thanks
Shawn

Select
 

Range(ActiveCell.Address, ActiveCell.Offset(0, 2).Address).Select
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Shawn" wrote:

I need a simple VBA to select the following range: the active cell and the
next to cells to the right. I want this to be relative to where ever the
active cell is. So I want it to select the active cell and the range to the
offset (0,2)


--
Thanks
Shawn

Select
 

ActiveCell.Resize(1, 3).Select

"Shawn" wrote:

I need a simple VBA to select the following range: the active cell and the
next to cells to the right. I want this to be relative to where ever the
active cell is. So I want it to select the active cell and the range to the
offset (0,2)


--
Thanks
Shawn