Copy from another workbook

Hi,

I get a new excel file every day that i need to work on. The thing is i cannot modify is in any way/save it in another location (do not ask....) . What i can do is copy the data to another excel file and then save it so i did something like this:

Please Login or Register  to view this content.

It works fine untill the last line (Pasting) which i don't really know why is not working. It spits out Subscription out of date but how is that possible? How can "A1" be out of range?!

Thanks in advance for your help!

Try removing the line in red. You already set the wb at the top of your code.

Please Login or Register  to view this content.