topic Internal: End of subsheet without corresponding start in Product Forum

Internal: End of subsheet without corresponding start

BenjaminDackerm — Wed, 28 Sep 2022 13:39:22 GMT

Hello

I get the Error Internal: End of subsheet without corresponding start when i try to get the number of rows in a column. Its a MS Excel VBO action, but the thing is, i only have one Excel sheet so there are no subsheets. I get the Excel Dokument from a sharebox, but i dont think that has anything to do with it. I open the Excel dokument with MS Excel VBO Aktion and safe it in a workbook so it should be attached to the Process.
How do i Fix this?

Re: Internal: End of subsheet without corresponding start

AidanMcArdle — Wed, 28 Sep 2022 13:53:13 GMT

Hi Benjamin.

The 'end of subsheet without corresponding start' error message is not related to Excel. Rather, the process is trying to move out of one Blue Prism subsheet (tab / page / Object action) but it does not know where to move to next.

This is usually caused when in debug mode you have manually set the next stage to work from - and so never stepped into the page. Because you didn't step in, then the process does not know where to go when it reaches the end point of the subsheet.