Select method of Range class failed

[RakeshDey]

Hi, I have to extract two excel column from two different workbooks into Blueprism. So while using "Get Worksheet Range as Collection" action for extracting data, I am getting the following error "Internal : Could not execute code stage because exception thrown by code stage: Select method of Range class failed". I have used the above action twice and the problem appears after the first range is extracted. I have ensured that all the data entered into the action are correct. Could anyone please help me to resolve this issue? Thanks in advance.

[Denis__Dennehy]

I have used that action a number of times with no problems so I am guessing there is something wrong either with your range syntax or the range you are trying to select itself?

[RakeshDey]

Thanks Dennis for your quick reply. I have found a work around by creating different instance for different workbooks and it's working fine.