I need to know whether macros can be used to "grab" data in a cell
reference, no matter where that cell may be. For instance, If I need
to insert a new column in sheet 4, and the column that gets shifted is
referenced in sheet 5, I want to make sure the reference can process
that change, so that I don't have to continuously change my formulas.


--
wnl2007
------------------------------------------------------------------------
wnl2007's Profile: http://www.excelforum.com/member.php...o&userid=24200
View this thread: http://www.excelforum.com/showthread...hreadid=378136