select the range where formula resides

press Ctrl+H
in Find What enter your current range
in Replace with enter new range
press Replace All.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=538328