View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lk
 
Posts: n/a
Default Replacing sheet reference in multiple cells...

You may want to look at Edit Links as an alternative to Replace. I find it
works easier than Replace in some cases.

"neilcarden" wrote:


Yes, that works - spot on thanks mate


--
neilcarden
------------------------------------------------------------------------
neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623
View this thread: http://www.excelforum.com/showthread...hreadid=554887