I want to select every second cell to the left of the active cell on the same row. So why doesn't the code below work?
Probably a very simple solution, as usual..Range(ActiveCell, ActiveCell.Offset(2, 0), _ ActiveCell.Offset(4, 0), ActiveCell.Offset(6, 0), _ ActiveCell.Offset(8, 0), ActiveCell.Offset(10, 0), _ ActiveCell.Offset(12, 0), ActiveCell.Offset(14, 0), _ ActiveCell.Offset(16, 0), ActiveCell.Offset(18, 0)).Select
Thanks in advance.