Hello,
I found the macro below on an earlier thread in this forum. It works well when I copy and paste from an excel spreadsheet. However, when I try to copy from WORD or a website, the data does not paste to the target cell in my spreadsheet (it's as if the data is lost before the final paste values statement in the macro). The macro does execute the same lines of code whether the source is from a spreadsheet or not.
Does anyone, know what changes could be made to this macro to allow the paste to use input copied from sources other than a spreadsheet, but still retain the formatting of the target spreadsheet cell?
Thank you for your help.
Bookmarks