Error with Copying Data from Workbook to another Workbook - Range Error
I am trying to copy the data from:
Workbook Get Outlook Metadata - Master
Worksheet Clean Results
To
Workbook AddRemovePurge
Worksheet AddEmailDump
The AddEmailDump is a running log, so the data being copied needs to be added to the last row, they column names are all the same, but I keep getting the Out of Range error and I can't seem to figure it out. The macro is assign the the "dump truck" on the Clean Results sheet. Any help would be greatly appreciated.
The clean results sheet does not have have a dump truck macro to review. Is that where you want us to create the macro for you or do have a macro that is not included.
Hi jwood1650,
Change this line of code in the Copy_Paste_Below_Last_Cell macro (commented as 3. Copy & Paste Data) from this...
...to this (note I've bolded my changes):
Please Login or Register to view this content.
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks