Hide numeric rows of dynamic range

[Code Flunkie]

I have this macro to hide rows, it sort of does what i want. but what i'd really like is it only to hide rows that have numbers in column A and ignore the rest. the values in column A are always positive i just need to hide the 0 values. also i was wondering if it is possible to hide a dynamic range from A14 to last used cell in column A. I'm still pretty new to excel VBA and any help would be much appreciated.

Thanks,

Chris

Please Login or Register  to view this content.

[Marcol]

Try this

Please Login or Register  to view this content.

This is a bit at odds with itself

....is it only to hide rows that have numbers in column A and ignore the rest. the values in column A are always positive i just need to hide the 0 values

I'm assuming that you want to leave only rows with numbers greater than 0 visible.
Can Column A contain Text?

Why not just filter excluding 0 and blanks, instead of using VBa?

Hope this helps

[Code Flunkie]

Wow, you're good. That was exactly what I was looking for

Thanks,

Chris