Hi,
Im getting an error (1004) on the ActiveSheet.Paste line near the bottom of the code below. I've seen this plenty elsewhere but cant seem to correct it... Could anyone help?
Please Login or Register to view this content.
Hi,
Im getting an error (1004) on the ActiveSheet.Paste line near the bottom of the code below. I've seen this plenty elsewhere but cant seem to correct it... Could anyone help?
Please Login or Register to view this content.
Last edited by Barking_Mad; 03-05-2014 at 08:23 AM. Reason: SOLVED!
Does this work?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi Norie,
The bottom part of code now reads:
However i'm getting an error: "Unable to get select property range of class" highlighting this line of code:Please Login or Register to view this content.
Please Login or Register to view this content.
Oops, remove .Select.
Also, remove these lines of code.
Please Login or Register to view this content.
Hi,
That works fine once, but when i run it again I get another "PasteSpecial method of range class failed" error, with this line,
that's further up the code in my original post...Please Login or Register to view this content.
You only mentioned ActiveSheet.Paste in the first post.
Anyway, try this.
Please Login or Register to view this content.
haha sorry i did. that's because im an idiot who doesnt know what he's doing
Thanks Norie, that works perfectly
No problem.
I actually didn't see the PasteSpecial at first, it was only when you pointed it out I found it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks