Hi,

I'm looking to write a procedure using vb in Excel to hide all rows where the content of column B is "DELETED". Could anyone help with this please?

Could the rowref property be used to solve this and if so could you give an example? Or could you help me with some code to move to the row below the current row in the spreadsheet, for example (in words):

Do
RowBelowProcedure:
GoTo Next Row
If cell in column B.value = "DELETED" Then
hide row
Else
GoTo RowBelowProcedure
Loop Until column B.value = ""

Thanks.