[Solved] Determining last active row [duplicate]

by


Your question is not “How to hide rows that have 0”, your code for that works already.
Your question title should be How to find ActiveRange

Asking the proper questions helps you find better solutions, quicker.

Dim ws as WorkSheet: Set ws = Sheets("Sheet1")
Dim lr as Long
lr = ws.Cells(Rows.Count, "E").End(xlUp).Row

For each cell in ws.Range(ws.Cells(5, "E"), ws.Cells(lr, "E"))
   If cell = 0 Then
      cell.EntireRow.Hidden = True
   End If
Next cell

replace Sheets("Sheet1") with whatever your SheetName is.

3

solved Determining last active row [duplicate]