I tried to copy the contents of Excel worksheet using “copy paste Pange”.
However, the object like figure is not copied.
How can I copy the worksheet contents includes objects?
Is there any copy method of the work sheet including objects for studioXcopyFrom.xlsx (9.3 KB) copyTo.xlsx (8.0 KB) ?
Thank you for your reply.
What I would like to do is to copy a worksheet contens to to other worksheet in another Excel workbook.
I am afraid “duplicate sheet” works only in the same workbook, right?
Do you have other solution?
Set the option “Cut, copy and sort inserted objects with their parent cells”. Click on File, Options, Advanced, and see the option in the “Cut, copy and paste” section.