Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return the cell reference of the drop down list selection. | Excel Worksheet Functions | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Automate selection of specific reference cells | Excel Discussion (Misc queries) | |||
Can a conditional cell formula reference data selection in a comb. | Excel Worksheet Functions | |||
Wide Selection of Absolute Reference Toggle | Excel Discussion (Misc queries) |