I’m trying to find the actual number of rows with data in it in an excel file when reading the whole column (ex: “J:J”). I understand the that I can set the read range, but the file I’m using will always be changing the number of rows based earlier processes so it’s necessary not to set the read range, because I don’t know what it’s going to be. I’ve tried using datatable.rows.count, but that only gives me the number of rows (1048575) blank or populated in column J.
I want use that value to meet the Do While condition later in my process
Needing a little help on this one guys…thanks!