Autofilter not working properly

G

Guest

When a column is autofiltered for blanks or nonblanks, the
next available row for data entry is wrong ie: the last
populated row is 300, but the row immediately below the
filtered area is something like 3275 (random figure). Any
ideas please, as this is driving me mad
 
M

mzehr

Hi,
Does this problem happen when you highlite the range, then
turn on autofilter? If not, you may have cells which at
one time had data in them and Excel needs to reset the
last cell.
Have a look at:
Last Cell - Resetting
http://www.mvps.org/dmcritchie/excel/lastcell.htm
You may have cells which at one time had data in them and
Excel needs to reset the last cell. Does this problem
happen when you highlite the range, then turn on
autofilter?
 
Top