I'm currently getting the below error when getting WorkSheet as a Collection:
'Internal : Could not execute code stage because exception thrown by code stage: Select method of Range class failed'
I have a loop going to get all the worksheets of a workbook into 1 Collection and this is happening on the 9th Sheet. I'm currently use 'Get Worksheet as Collection Offset' as I want it to get a Collection for the table that starts in cell 'A13' of every sheet.
I've checked all the sheets and I can't see that anything is different with this one.
Any ideas?
'Internal : Could not execute code stage because exception thrown by code stage: Select method of Range class failed'
I have a loop going to get all the worksheets of a workbook into 1 Collection and this is happening on the 9th Sheet. I'm currently use 'Get Worksheet as Collection Offset' as I want it to get a Collection for the table that starts in cell 'A13' of every sheet.
I've checked all the sheets and I can't see that anything is different with this one.
Any ideas?