alan myers
Board Regular
- Joined
- Oct 31, 2017
- Messages
- 119
- Office Version
- 365
- Platform
- Windows
how can i hide a row if say d5 = 0
then check d6 if 0 hide that row and so on
then check d6 if 0 hide that row and so on
Sub MM1()
Dim lr As Long, r As Long
lr = Cells(Rows.Count, "D").End(xlUp).Row
For r = lr To 2 Step -1
If Cells(r, "D").Value = 0 Then
Rows(r).Hidden = True
End If
Next r
End Sub
I am a little confused on what you are trying to accomplish here.is there a way lets say d6 has a 1 than i change it to 0 would like it to change automatic is that liike a change event
row 27 2 x 6 Ground Contact AC2® Green Pressure Treated Lumber | treated 2x6x6' | $5.89 | 6 | $35.34 | Band & Joist | treated | 2x6 | Menards |