Navigating with .End(XlDown) issue

[CountTepes]

I have noticed, that after deleting data in a column then navigating with ctrl-{DownArrow} or even indeed with VBA Range.End(XlDown), the navigation is wrong.

By that I mean that what happens, is that it will ignore empty cells, bypassing them completely. Stop in the middle of a block of data, or stop in the middle of a block of empty cells.

Reversing the navigation, it still stops in the same places.

Any ideas, advice or reasons for this would be very welcome.

 

[CountTepes]

The file has gone. I closed without saving as It was only being used for code snippet testing.

Next time it happens, I'll post it.