07-15-2015, 01:55 PM
I tested, this always shows the last used row number, as displayed in Excel.
out removeNamesList.len
out SANamesCheckList.len
If other columns have more rows, the array will have some empty elements in tail. Then skip empty cells: if(array[...].len=0) continue
out removeNamesList.len
out SANamesCheckList.len
If other columns have more rows, the array will have some empty elements in tail. Then skip empty cells: if(array[...].len=0) continue