Copy and Paste Worksheet Range

[CamiCat]

View attachment 1548698634312.png
hello friends,
I' m trying to copy and pasting from one worksheet to another.
I get the following error:
Failed to copy worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
How to solve it?
Thank you so much,
cami

 

[bot1robot]

@CamiCat
Can you pls try entering Appropriate Source range and Destination Range ?Also make sure you are entering correct path for source workbook and destination workbook parameter.

Hope this helps.

 

[CamiCat]

Hello @bot1robot,

have you got a screenshot of an example of how to to do it correctly?
Thank you,
cami

 

[bot1robot]

@CamiCat

The error Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) occurs most of the time due to error in input parameter for Source / Destination file path (Full file path ) or Invalid Source Range or Target range .

Could you try
1.Create Worksheet as collection.
2. Write Collection to excel

Hope this helps.

 

[CamiCat]

Thank you so much @bot1robot.
I'll try with your suggestion and post the feedback
Thank you so much,
Cami