Hello all, I'm fairly new to VBA and I can't seem to get my code to work.
The Error occurs at "wb2.Range("L2:L1000").PasteSpecial Paste:=xlPasteValues" in red. I'm not sure how efficient my code is, so any help would be greatly appreciated. I'm trying to take this one step at a time, but my next step will be to copy only the cells with content using:
and paste those.
Moderator's Note: Welcome to the forum. In posting codes the codes should be enclosed with code tags. Select the coe then hit the "#" sign. I'll do it for now. Thank you.
Bookmarks