Hi

Have a look at the INDIRECT function. There is some useful info on Chip's
site:

http://www.cpearson.com/excel/indirect.htm

Hope this helps.
Andy.

"Neel" <Neel@discussions.microsoft.com> wrote in message
news:35DF4139-87F0-4000-9A75-C91FCA2D0090@microsoft.com...
> 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
>