View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
foxspirit[_2_] foxspirit[_2_] is offline
external usenet poster
 
Posts: 1
Default Need an auto update formula macro


Is it possible to refer to the cells by cell name (lets say I name A40
Bob) when doing this so it doesn't matter if I move cell A40 to D5,
because the macro will search for its name "Bob" instead?


--
foxspirit
------------------------------------------------------------------------
foxspirit's Profile: http://www.excelforum.com/member.php...o&userid=31264
View this thread: http://www.excelforum.com/showthread...hreadid=512253