View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Pete McCOsh Pete McCOsh is offline
external usenet poster
 
Posts: 64
Default 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
.