storing address of active cell

[steve_bris]

Hi.

This might be a silly question but I'm using access VBA and I want to record the position of the active cell at certain point of my program........how can I store this addresses........

ie....will this make rngAdd equal to the position of the active cell at the moment, so I can store it and use it later ?


Dim rngNow as range

rngNow = ActiveCell.address

 

[llkhoutx]

Screen.ActiveControl.Name gives the (string) names of the current cell.