I've brought this up before but never really got it fixed. See attached zip file.
Both sheet.UsedRange.End.Row and sheet.row.length gives me = 364.
But the actual row# of the last line should be 240.
Why is sheet.UsedRange.End.Row and sheet.row.length giving me 364 when it should be 240?
ex.zip