Anyone know how to paste special values, but keep the comments? Thank you.
Anyone know how to paste special values, but keep the comments? Thank you.
2 PasteSpecial statements to the same range, one after the other. First to paste values, second to paste comments. Use the macro recorder to get the basic code.
I tired that thanks, but as soon as I paste values, the comments disappear.
It works for me!
Post the code you came up with,..
figured out a quick way to solve the problem. Paste Special Values, then paste special "Values & Source Formatting" will bring the comments back. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks