Hello, is there a way to use the excellookuprange activity but change the range to check every single row? For example, instead of putting “Range: B2:B100” could I set it to “Range: B2: B*” so it looks through every row? I am running a program where the number of rows constantly changes so sometimes it may be larger than 100. Thank you in advance.
You can count the last row of excel.
You can Give range as “B:B”
Thank you so much!
Thank you very much!