Loop to hide rows containing a value

[MoonWeazel]

Hey All,

This code *should* loop through Column A and hide all the rows that don't contain a value (specified by a userform which i haven't done yet!)

Here is the code:

Please Login or Register  to view this content.

It loops through the rows without probs but doesn't hide any of the rows!

Is probably something really daft!

TIA,

MoonWeazel

[tom1977]

Hi with this

Please Login or Register  to view this content.

your code will run long long time especially with excel >2007
set the range for start

[MoonWeazel]

Thanks for the tip Tom1977 - that was one of the tidyup actions I had on my list. The data at the moment is quite small so doesn't take long to whizz through.