View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neel
 
Posts: n/a
Default Change the work sheet name in a formula by using cell reference

Hi

Please let me know how to change the work sheet name in a formula by using a
cell reference.

Presently I am using Find & Replace command to change the formulas.

ie. lets say there are two work sheet ABC & DCB where, I want to change the
work sheet name in a formula "ABC" to "DCB" by changing a cell (Cell - A1)
which contains "ABC" to "DCB".

Thanks

Neel