Hi,
I am using this code to copy and paste to a destination, but I want the result to be pasted as TEXT, anyone can help?
Please do not ask me to change the way of pasting because I will have to change the whole macro which is really long.
Thanks.
Please Login or Register to view this content.
Hello calvinle,
The Copy method of the range will copy everything. To make the destination text only, the easiest method is to change the destination format.
This version of your macro does just that. It checks the number of rows and adjusts the destination cells to that same number and then changes the cell format to text.
Please Login or Register to view this content.
Last edited by Leith Ross; 10-23-2014 at 01:51 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you!!
Hello calvinle,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks