Hi

If you copy as values then there are no links anymore in the worksheet?
Maybe a range name?

Send me a copy (private)of the sheet where you use the PasteSpecial code
I take a look at it then


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



"hyderabadwala" wrote in message
...
Ron,
I thought the "ask to update automatic links" was taken care..but unfortunately I am still getting the error message. Any idea
why?

Thanks

Hyderabadwala