Macro to hide rows containing data in range

[jpruffle]

Hi,

I have the following Macro that hides rows that contain old dates (in column B) in a range:

Please Login or Register  to view this content.

However is there a way I can get it to only calculate rows if there is actually data in column B? At present it calculates for the whole range so it takes several seconds.

Is this possible? Thank you in advance.

[royUK]

This should be faster, with no screen flicker

Please Login or Register  to view this content.

Without seeing your data layout it's hard to say, but autofilter would be quicker than looping

[jpruffle]

That's fantastic thank you. Works a treat.