HOW TO STORE CURRENT COLUMN & ROW
 

I need a current_row() & current_col() function so I can store row / column
where user places cursor. Is there something built in so I can get this
info? I need to store row and column info to a variable.

TIA

HOW TO STORE CURRENT COLUMN & ROW
 

Use this

Arow = ActiveCell.Row
Acol = ActiveCell.Column



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"tootles" wrote in message news:nR0fb.33094$AH4.17589@lakeread06...
I need a current_row() & current_col() function so I can store row / column
where user places cursor. Is there something built in so I can get this
info? I need to store row and column info to a variable.

TIA