Not what I'm looking for. Assume my active cell is someplace(location
unknown). But at some point in my macro I need to put its location
into a variable for use later in the macro. How do I pass that
location to the variable?

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=472859