Want to highlight a cell (for example A7), highlight it with a background
colour, move right one cell, highlight it with a background colour, move
right one cell, highlight it - for a total of 15 cells.
If I do this by recording a macro, when I run the macro from cell A15, the
macro highlights A15 then moves to B7 not B15.
How can I accomplish highlighting a continguous range of 15 horizontal cells?