When using Excel I have selected a range of cells. I can then use the Tab key
to keep the selection but move the active cell to the next cell in the row.
when the last cell on the row has bee selected, the active cell becomes the
next cell on the next row all within the selected range. How is this achieved
in VBA