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…

Excel Look Up Range, Changing Range?

jhj3627 (HJ) June 1, 2020, 1:28am 2

Hi.
You can count the last row of excel.

2 Likes