Ok I am trying to make a little macro that will hide cells that contain "0" or "" (nothing). The following code below works when I just do it for one cell:

If Cells(13, 3) = "" Or Cells(13, 3) = "0" Then
Rows("12:13").Hidden = True
End If


But the following code below does not work when there is an actual # in cell C24 and C25 & C26 are empty, it will still hide the cells. This happens when C25 has a # in it and C24 & C26 are empty. BUT when C24 & C25 are empty, and C26 has a # in it, the cells won't be made hidden...

If Cells(24, 3) = "" Or Cells(24, 3) = "0" & _
Cells(25, 3) = "" Or Cells(25, 3) = "0" & _
Cells(26, 3) = "" Or Cells(26, 3) = "0" Then
Rows("23:26").Hidden = True
Else
Rows("23:26").Hidden = False
End If


And I added the "Else" this morning and prior to that the same results occurred. If anyone can help I would greatly appreciate it! Thanks!

 

I'm not an Excel expert, but I think your ANDs and ORs might be getting "mixed up" due to operator precedence rules. Will it let you put parentheses around the OR conditions, like this?

If (Cells(24, 3) = "" Or Cells(24, 3) = "0") & _
(Cells(25, 3) = "" Or Cells(25, 3) = "0") & _
(Cells(26, 3) = "" Or Cells(26, 3) = "0") Then
Rows("23:26").Hidden = True
Else
Rows("23:26").Hidden = False
End If

 

I get a "Type mismatch" error when I try to do that..

 

BUT I didn't put parentheses around the first line, and just the bottom 2 lines and it worked! Thanks and repped!

 

O no.. but now when all 3 are empty it won't hide the cells...

If Cells(24, 3) = "" Or Cells(24, 3) = "0" & _
(Cells(25, 3) = "" Or Cells(25, 3) = "0") & _
(Cells(26, 3) = "" Or Cells(26, 3) = "0") Then
Rows("23:26").Hidden = True
Else
Rows("23:26").Hidden = False
End If

 

Hmmm... dunno why it won't let you put them around the 1st line... Have you tried this?

If ((Cells(24, 3) = "" Or Cells(24, 3) = "0") & _
(Cells(25, 3) = "" Or Cells(25, 3) = "0") & _
(Cells(26, 3) = "" Or Cells(26, 3) = "0")) Then
Rows("23:26").Hidden = True
Else
Rows("23:26").Hidden = False
End If

 

Same type mismatch error

 

This could be my problem..

http://support.microsoft.com/kb/821292

 

I am going to try the update, but this is for work, so even if it works here it really has to work at work. So if anyone has a solution besides the update (if that even works) then I'd appreciate it!

 

Update didn't work

 

Maybe you need to be using "AND" instead of "&"? From my Excel Help, it looks like "&" is a string concatenation operator, and "AND" is a comparison operator. Worth a shot, right?


If ((Cells(24, 3) = "" Or Cells(24, 3) = "0") AND _
(Cells(25, 3) = "" Or Cells(25, 3) = "0") AND _
(Cells(26, 3) = "" Or Cells(26, 3) = "0")) Then
Rows("23:26").Hidden = True
Else
Rows("23:26").Hidden = False
End If

 

Yup worked like a charm.. thanks again! This concludes the hornyleprechaun and elessar excel help thread

 

This worked for me.
Sub Macro1()
If Cells(24, 3) = vbEmpty Or Cells(24, 3) = "0" & _
Cells(25, 3) = vbEmpty Or Cells(25, 3) = "0" & _
Cells(26, 3) = vbEmpty Or Cells(26, 3) = "0" Then
Rows("23:26").Hidden = True
Else
Rows("23:26").Hidden = False
End If
End Sub

 

stop doing work on your birthday!!

 

Awesome! Now like sonny said, get the hell out there & start celebrating your birthday, dude!!

 

I can't yet! My g/f is getting her hair highlighted, so whenever she is done I can leave and start boozing