I initially export 268 records to a Excel file called Temp.xls, which already exists but which is deleted prior to export.

I have the following code: -

lngRow = ActiveSheet.UsedRange.Rows.Count

However I get a value of 5495. When I open Temp.xls and do Ctrl+End it does indeed go to the 5495th record. Why does this happen?