Is there anyway I can capture the previous activecell prior to the one im on?


Posted by Adam K. on February 28, 2000 10:28 AM

I need to capture the previous activecell.
Is there any solution.
Can you run a macro just from clicking on a cell.
I am using worksheet _ change but i need to capture a variable before the macro starts.
any backwards solutions

thanks



Posted by Jaime on March 09, 2000 12:54 PM

activecell.Previous.Address