Change Range Selection VBA

[Razor303]

Hi, i am using Range(ActiveCell, ActiveCell.Offset(0, 2)).Select, Witch selects the active cell and two cells to the right.
I need code to then select the middle cell of the range
thaks to anyone how helps me with this.

 

[Norie]

What range do you want to you select exactly?

This will select the active cell and the 2 cells to the right.

ActiveCell.Resize(0,2).Select

This the cell 2 cells to the right.

ActiveCell.Offset(,2).Select