Conditional Expression

[edhaddock]

In a macro I need to hide a number of rows in a worksheet if the content of a cell is "Purchasing". If it is true, hide the rows, if not skip the hide and go to the next command but stay in the macro. Can anyone help me? My VB is very weak.

Thanks
Ed

[mrice]

Something like

Sub Test()
If Range("A1") = "Purchasing" Then
Rows("2:5").RowHeight = 0
End If

'Other macro code goes here
End Sub

[VBA Noob]

I assume you want every occurrence of Purchasing in a range to hide the row.

Try this

Please Login or Register  to view this content.

VBA Noob

[edhaddock]

Thank you very much. I'm sure I can make one of these work.

Ed