I have been using the extension 'UsedRange.Rows.Count' to find the last row used on a worksheet for longer than I care to remember and have today found a problem.
I generally produce worksheets that start at Row1, but today had reason to start at Row10.
The code I have always used to loop from the first to the last line for a worksheet set to ShtName is
For Looper = 1 to ShtName.UsedRange.Rows.Count
Imagine my surprise when this stopped 10 lines short of the end. Has anyone else come across this problem and how have they solved it? Is there a way of getting the number of the final row used in a worksheet? I have got around this by inserting a value in cell A1 at the start of the module and then removing it at the end of the module, but this seems to be cheating.