you're a master thanksHi ,
you can add new action in ms excel VBO. no need to add namespaces add action in existing excel VBO.
Hi Janejeba,
create new action in MS Excel VBO and named as Find
Design flow like bellow
View attachment 4450
StartUp parameter will be
View attachment 4451
Code Stage input parameter will be
View attachment 4452
code stage output parameter
View attachment 4453
Code stage code will be
View attachment 4454
Then just passed values from process and you will get output as cell reference of first occurrence of string
View attachment 4455
Hello guys,
First of all thank you for this VBO.
However I have an issue, I did all like you mentionned above but I still have an error :
View attachment 5723
Any idea on how to fix it ?
Thank you in advance,
Kind regards,
Dorian K.
Hi shameer,
Unfortunately this will result you only the first occurrence, what you can do is put this code inside a loop and use the cell reference you get as the AFTER input in the find function, this will give you the next occurrence, you can keep looping until there is an exception thrown when the function finds nothing and store every output cell in a collection
Hi Nathan,Anyone using this code? I've got the following error:
Public member 'Find' on type 'Range' not found.