Get Worksheet as collection with worksheet row number as field

LaurentDELOBEL2 — Tue, 22 Jun 2021 20:55:00 GMT

Hello,

I have the following scenario which I do not know how to deal with.

I have to apply filter in an excel worksheet. Once I applied this filter, I have to set yes or no in the filtered column C depending the value in the filtered column B.
In order to set the value yes or no in column C I need to know the row number of the cell
Is there any code I can use to add one more column in the collection in order to get this row number when I use get worksheet as collection ?

Thanks by advance

------------------------------
Laurent DELOBELLE
------------------------------

RE: Get Worksheet as collection with worksheet row number as field

EmersonF — Wed, 23 Jun 2021 01:28:00 GMT

hello, try using the get last row action with the filtered column, it should give you the amount of visible row. or you can use the auto fill action to make it "generate" a counter, from the first line to the last visible line,

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

topic Get Worksheet as collection with worksheet row number as field in Product Forum

Get Worksheet as collection with worksheet row number as field

RE: Get Worksheet as collection with worksheet row number as field