You have links to other workbooks or sheets

You can paste special as values
After the copy line add this code

Cells.Copy
Cells.PasteSpecial xlPasteValues
Cells(1).Select
Application.CutCopyMode = False




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"hyderabadwala" wrote in message
...
Hi Ron,
Thanks for the advice..it worked. But i am still getting the "automatic link" message, how do i fix it?

Thanks