G
Guest
Guest
Hi,
In my haste i guess i didn't explain well
enough what im trying to do. I'll try again:
Say i have a range from A6:A1000, if in any
row in column A witin A6:A1000 contains a "0"
then that row is hidden. I can get it to work
with this "lame" code but it's ridiculous
as you can see....
Private Sub CommandButton1_Click()
If [A6,A7,A8,A9].Value > 0 Then
Range("A6,A7,A8,A9").EntireRow.Hidden = False
End If
If [A6].Value = 0 Then
Range("A6"). EntireRow.Hidden = True
End If
If [A7].Value = 0 Then
Range("A7"). EntireRow.Hidden = True
End If
End Sub
'It works "but it's obviously not the way to
go to check 1,000 rows"
Any help would be appreciated
James
In my haste i guess i didn't explain well
enough what im trying to do. I'll try again:
Say i have a range from A6:A1000, if in any
row in column A witin A6:A1000 contains a "0"
then that row is hidden. I can get it to work
with this "lame" code but it's ridiculous
as you can see....
Private Sub CommandButton1_Click()
If [A6,A7,A8,A9].Value > 0 Then
Range("A6,A7,A8,A9").EntireRow.Hidden = False
End If
If [A6].Value = 0 Then
Range("A6"). EntireRow.Hidden = True
End If
If [A7].Value = 0 Then
Range("A7"). EntireRow.Hidden = True
End If
End Sub
'It works "but it's obviously not the way to
go to check 1,000 rows"
Any help would be appreciated
James