1. Your Paste code line is not as explicit as that required. We should
evidently, use something like :-
'-----------------------------------------------------------------------------
ActiveSheet.Paste Destination:=Worksheets(1).Range("C5")
'-----------------------------------------------------------------------------

Seems like a "belt and braces" approach - but it is probably "
feature, not a bug". Despite this, I do get inexplicable problems wit
Paste at times. Generally find that the following produces bette
results than using Select or Activate:-

'----------------------------------------------------------------------------
Application.Goto reference:=wb.Worksheets(1).Range("C5")
'----------------------------------------------------------------------------

--
Message posted from http://www.ExcelForum.com