Hi Terry,
If you re-open the Excel workbook and press Ctrl-End, is that now taking you the correct last row? If not, that suggests you only deleted any cell content in those rows, not the entire rows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|