Range Select

[Marco Rodas]

What is the code to have a macro select the active cell
and the adjacent two cells to the left, regardless of
where the active cell is? I have tried:


Range(ActiveCell.Select, ActiveCell.Offset (0, -2)).Select


with no luck.

Thanks.

 

[Roy]

Try:

Range(ActiveCell, ActiveCell.Offset(0, -2)).Select

 

[Dick Kusleika]

Marco

The Select part of ActiveCell.Select is the problem. Just use ActiveCell,
the Select is on the whole range

Range(ActiveCell, ActiveCell.Offset(0,-2)).Select

or

ActiveCell.Offset(,-2).Resize(,3).Select

is another way.