Hide Row depending on Cell Value

[Jim McEwan]

Hi There,

I would like to run a macro that searches column [AS] and hides any rows in that column that contain "0", can anyone help?

Thanks

JM

[stnkynts]

Try this:

Please Login or Register  to view this content.

[Jim McEwan]

Hi stnkynts,

This works in theory - although I have over 3000 rows to check, so this way would take and absolute age to execute. Do you know of any faster ways?

Regards,

JM

[stnkynts]

Yeah, I could do it by autofilter, advancedfilter, reg expression. I wouldn't think the code would take that long to run though. How long did it take on your workbook?

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[stnkynts]

@John, he would need to hide the 0's

Please Login or Register  to view this content.

[JOHN H. DAVIS]

@John, he would need to hide the 0's

Please Login or Register  to view this content.

Oops. Good catch.