Good evening.
I have two lines of code that work great. I copy specific columns from Sheet1 and the results are pasted to different columns in Sheet2 (code included below). However, I'd like to sort the results (by column "E" and then "L") before they are posted to Sheet2. I'm new to VBA, so I'm not sure how to insert a sort function before the pasting begins, given the code below. It appears my code is both copying and pasting. Thoughts?
Please Login or Register to view this content.
Have you tried the macro recorder? Just start macro record and do the sorting on column E, and then try to amend the code from there.
多么想要告诉你 我好喜欢你
Thank you, Millz. That's a good idea. I didn't know I could turn on the recorder and build mid-code. Actually, is that what I do? Rookie question.
What the recorder does is actually capture what you do and convert it into the VBA equivalent (for most of the actions). If you only performed sorting while recording is on, and then stops recording, the macro would have only the code that would perform the sort.
I've learnt most of my basic stuff through recording and amending. You should be able to analyse what the recorded code is doing, make some amendments and then put it before your "copy and paste" segment of code.
Thank you very much! I've certainly underestimated the power of the recorder. But not after tonight. Have a nice evening.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks