Why do you need to save the address of the active cell?

--JP

On Sep 22, 4:24*pm, "Bob" wrote:
Hi Everyone:

In excel 2003, I have an userform. *When the user closes the form, it should
save somewhere the address of the active cell on the active sheet. *Then,
when ever the form opens, I want it to recall the active cell on the current
active sheet that it saved before. *Of course this address may be different
for different sheets. *The ideal place would be in the tag of the active
sheet. *I tried a few things but it did not work. *Any ideas what is the
best way to achieve saving he address. *Thanks for all your help.

Bob