I have used sheet names as part of my formula, however, I have other
sheets with the same design. I have made a copy of the sheet, but it
carries the original sheet name. Is there a way of using the find and
replace feature to change the sheet name in the formula e.g. sheet1!a10
to sheet2!a10

I have a large number of cells that require the sheet name to be
changed, hence my question. I hope someone has an answer.

Thanks


--
Tony_CC
------------------------------------------------------------------------
Tony_CC's Profile: http://www.excelforum.com/member.php...o&userid=35595
View this thread: http://www.excelforum.com/showthread...hreadid=553604