The following code won't let me copy from the first workbook. I get a run time 1004 error stating "That command cannot be used on multiple selections".
I would rather not have to copy this by column for each of the 4 workbooks so any help getting this in just 4 copy/pastes would be greatly appreciated.
Please Login or Register to view this content.
Last edited by Sc0tt1e; 02-27-2014 at 11:33 AM.
Bumpity bump
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.
Almost there, I'm getting an error regarding the next i
I get a Next without For error??? Any ideas what that is?
Please Login or Register to view this content.
Bump, help!
Hi,
You have line 5 this : For i = 1 To 4
In the middle of your code : Next i
And in the end of your code too: Next i !!
You have to put another for i= 1 to 4 in your code or delete one next i depending on what you want to do.
Ohhhh, I thought the original i = 1-4 would work for both.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks