still calculating slowly

[palaeontology]

I have a series of worksheets that each used to have data down to about 16 000 rows.

Calculation was extremely slow, so I've re-worked the sheets so there is only data down to row 1500 in each sheet, but calculation is still just as slow as before, AND the vertical side scroll bar still seems to think there are 16 000 rows ..... by that I mean the little rectangle you grab in the vertical scroll bar hovers about 1/10th the way down the bar when I'm in the 1500th row.

Why does the worksheet think there are still 16 000 rows of data when I deleted rows 1 501 to 16 000 in all the sheets ?

I hope this makes sense.

Kind regards,

Chris

 

[Alex Blakenburg]

After you deleted the rows did you hit "Save". The UsedRange does not reset until you either hit Save or use the UsedRange property in VBA.

 

[palaeontology]

That did the trick .... thankyou

 

[Alex Blakenburg]

No problem, thanks for letting me know.