Hello all! So I'm trying to copy and paste a column of data (Column D in my case). It's about 7k rows long and I need to move it from one worksheet to another worksheet in the same workbook. I can't have the top row (it's a title) so I made a quick data item with the row # (minus 1). I keep getting the following error: : Failed to copy worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
My hunch, after reading some of the previous posts is that it's my source and destination workbook. I've included a screen shot of the my properties. Any advice? I've also tried using .xls instead of .xlsx to no avail. I've also tried removing the spaces as well.
View attachment 1562635979761.png
My hunch, after reading some of the previous posts is that it's my source and destination workbook. I've included a screen shot of the my properties. Any advice? I've also tried using .xls instead of .xlsx to no avail. I've also tried removing the spaces as well.
View attachment 1562635979761.png