There is rarely any reason to select a cell in VBA

for each cell in Range("A1:F10")
msbox cell.Address
Next

if you want to loop through the user's selection

for each cell in selection

--
Regards,
Tom Ogilvy




"diddy_david" wrote:

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