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?