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?

Please Login or Register  to view this content.