Hey everyone, I have another problem I need to solve. How could I alter the script below to copy specific columns, B, H J to the destination sheet starting in column B? I I'm stumped on this. Trying to find a solution but so far not able.
Please Login or Register to view this content.
Last edited by anthony1312002; 10-12-2017 at 02:58 PM.
Something like this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
How would I apply the pastespecial?
By using another row (the colon does that) -
and thanks for the rep!Please Login or Register to view this content.
No problem. Thank you for your great help!!
Last edited by anthony1312002; 10-13-2017 at 07:46 AM.
Hey xladept,
I'm getting a PasteSpecial Method or Range class failed error. Why would that be?
Please Login or Register to view this content.
Because the whole column won't fit if you're not pasting from the first row.
Last edited by xladept; 10-13-2017 at 12:00 PM.
So how do I get around that? Sorry if I seem a little lost.
Maybe:
Please Login or Register to view this content.
Good afternoon.
The special paste method requires that the target worksheet be selected.
Select the spreadsheet and destination cell in your code, and use the special activecell.pastes
Something like this:
Sheets3.range ("a1"). Select
activecell.PasteSpecial xlPasteValues
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks