I have a macro that I'm using to copy a column of numbers then paste the column on a separate sheet. The source column will change every month, so the target column is being pasted to the immediate right of the previous paste.
My problem is I don't know how to change the Macro so that it will paste special values from the source column.
Thanks in advance for any assistance.
Here is my code:
Please Login or Register to view this content.
Last edited by newyorkhoosier; 11-30-2012 at 02:57 AM. Reason: incorrect format
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Patel, thank you! That worked perfectly.
Do you know how to add paste values & Source formatting?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks