26
Views
3
Comments
Solved
[advanced excel]Worksheet position out of range occur when call Worksheet_select
Question

Hello outsystems teams

let me ask some questions using advanced excel.

I created very simple action.Please check out my picture.

unfortunately I am facing some error.

When I call Worksheet_Select action the error message is[Worksheet position out of range. ] appear.

I don`t know why my action is so simple.Someone help me please how can I fix this error.

Regards

Rank: #2161
Solution

Pedro Marques wrote:

Hello Pedro Marques

Thanks you very much it is help for me.

Thanks you.

Hi May,

I believe you are trying to select a worksheet that doesn't exist because you need to create it first, using the "WorkBook_AddSheet" function.

Something like this:


Then you select in the worksheet you just created in "Worksheet_Select".

Let me know if this helps,

Pedro

 

 

Rank: #647

Hi May,

I believe you are trying to select a worksheet that doesn't exist because you need to create it first, using the "WorkBook_AddSheet" function.

Something like this:


Then you select in the worksheet you just created in "Worksheet_Select".

Let me know if this helps,

Pedro

Rank: #647

Hi May,


If the answer helped you could you set it as the solution? This way, others with the same question might find the solution more easily.