row reference from selection
 

I've been trying to get a row reference by pulling it from
the location of the button, but seem to get "object not
supported error'.

So, I'd like to get the row reference by pulling it from
the active cell selection.

Does anyone know how to retrive the row refence (not
count) so I can pass this though my function (i.e. E17
could give me 17 as the value)??

Many thanks in advance

mark

row reference from selection
 

Mark,

Activecell.Row

Cheers, Pete.

-----Original Message-----
I've been trying to get a row reference by pulling it
from
the location of the button, but seem to get "object not
supported error'.

So, I'd like to get the row reference by pulling it from
the active cell selection.

Does anyone know how to retrive the row refence (not
count) so I can pass this though my function (i.e. E17
could give me 17 as the value)??

Many thanks in advance

mark
.