HELPPPP USING ADDRESS PROPERTY

I am trying to use the address property to remeber the last location of the activecell before I go to a new column to search for a name. After I have finished my search I want to return to the cell that I had previously been in. How do i make the active cell the address before I did my search?

for ex:
dim lastposition as variant

lastposition = activecell.address
do some searching
'****NOW SET ACTIVE CELL TO 'lastposition' before I searched