As per another question of mine, I have to read hundreds of sheets with ranges that start at B35 but have no specific number of rows.
However, one thing that really shows where my needed range ends, is the word TOTAL
So I tried a simple Lookup Range from B35 to B100 in a single sheet, just to test, sending the result to a string variable and then, outside Excel App Scope, showing that String Variable in a message box (just for test and checking if it’s working)
But no… the Message Box appears empty.
However, the TOTAL word I am looking up is inside a 5 columns merged cell.
When I unmerged the cells, the Message Box found the cell location (B44 in the specific sheet I was using for test)
Well, obviously there is no way I will try to unmerge hundreds of sheets, right?