I have a fairly simple macro that copies a range of cells from one sheet and pastes them to another sheet in the first blank row. one or more of the original cells could contain inserted objects (for example, a microsoft Word icon - Insert > Object > Word Doc > Display as icon). My macro won't copy over the inserted object and I found through manual recording of macros that the non-special paste command (Ctrl-V or right-click Paste) does paste objects, but pastespecial does not include copied objects. Any ideas as to how to include objects in the paste?
Bookmarks