Just like the ActiveSheet is an object containing all the properties of the
currently active sheet, there is an ActiveCell object that contains all the
properties of the currently selected cell. Note I said cell... there is also
a Selection object that contains all of the properties of the current
selection, whether that be a single cell or a group of cells (in a selection
of multiple cells, there is still a single active cell... the ActiveCell
object references it). So, to get the row that the active cell is on, just
ask the ActiveCell object for it...

MsgBox ActiveCell.Row

--
Rick (MVP - Excel)


"kirkm" wrote in message ...
Thanks Guys,

I got into there OK but can't see anything
for detecting the active row, does it exist in that enviroment, or is
it detected some other way?

Thanks - Kirk