Where to use invoke vba?

Help
1

Hi, I have the VBA codes but not sure where to use the invoke activity.

Previously, It was after write range and it worked.

image
image577×612 13.8 KB

But now, I putting in different place but it’s not working.

image
image772×727 27.1 KB

The VBA is suppose to highlight the rows that has ‘FALSE’. Pls help.

Thank you xoxo

2

Hi @sangasangasanga

For sequence you are using it on the right place but i think you should check the if condition for this. If that is correct I guess previously you were using the Excel Application Scope instead.

Thanks,
Prankur

1 Like
3

My If condition works. It writes ranges for both ‘then’ and ‘else’. But the invoke VBA doesn’t work after i place it there

4

Did you try Excel Application Scope instead?

5

It works after I use excel application scope. Does that mean when invoking vba it always must be in an excel application scope?

6

@sangasangasanga - The invoke VBA activity you are using is a part Excel package, that is why it should be in the Excel Application Scope only. Hope this answers the question.

image

Thanks,
Prankur

1 Like