G
Guest
Guest
Hi, i can hide Unhide 1 row With:
Option Explicit
If Range ("D6") = 0 Then
Range("D6").EntireRow.Hidden = True
If Range ("D6") > 0 Then
Range("D6").EntireRow.Hidden = False
---------
What i'm trying to achive is:
If the Range of ("D6:D1000")has a "0" then
that row is hidden
Thanks for any help,
James
Option Explicit
If Range ("D6") = 0 Then
Range("D6").EntireRow.Hidden = True
If Range ("D6") > 0 Then
Range("D6").EntireRow.Hidden = False
---------
What i'm trying to achive is:
If the Range of ("D6:D1000")has a "0" then
that row is hidden
Thanks for any help,
James