Hi VJ

You can do this

Select all cells
Use replace "=" to " =" (see the space before =)
Without quotes

Copy the sheet

And in the new workbook
Use replace " =" to "=" Without quotes

If you need help to do this in code post your macro
and I will try to help you


--
Regards Ron de Bruin
http://www.rondebruin.nl


"VJ" wrote in message ...
I am copying a sheet from one workbook (wb1) to another workbook(wb2) through
a VBA macro.

I can copy the sheet but there is one problem in copying process. After
copying I can see the following code in my cell.

=+'[wb1.xls]Sheet2'!C11

Is there any way to get rid of '[wb1.xls]' portion which is name of the
workbook? I need to keep Sheet2 but dont want to keep the name of the
workbook.

Help would really be appreciated.

Thanks and rgds,