I have a worksheet, using 1845 rows and columns out to AB. We use the
AutoFilter command on the Data menu constantly, and are getting a strange
behaviour.
When the filter is applied, it shows the appropriate data, but hides all the
rows from 1845 down to 3606 and then displays the remaining from 3606 to
65536.
What I can not figure out is why are rows 1845 to 3606 being hidden. There
is nothing in them. To be sure of this, I selected all the rows from 1846 to
65536 and over to column IV and from the Edit menu, select Clear - Formats
and then Clear - All, to no avail.
What am I missing here? It is causing some difficulties with formulas on
other worksheets linked to this sheet.
Thank you
Marsh