I need to select a range of rows to hide rows with no data in after a macro has imported data.
I have the below
Sub HideRows()
Dim lngLastRow2 As Long
Dim i As Long
With Sheets("Gross Up")
'Find the last row in column B
lngLastRow2 = .Range("B65535").End(xlUp).Row
Range("(lngLastRow2 + 1):415").Select
Selection.EntireRow.Hidden = True
End With
End Sub
The range select does not work (i know i do not have it in the right context), but i can't work out how to put it
anyone help please?
I have the below
Sub HideRows()
Dim lngLastRow2 As Long
Dim i As Long
With Sheets("Gross Up")
'Find the last row in column B
lngLastRow2 = .Range("B65535").End(xlUp).Row
Range("(lngLastRow2 + 1):415").Select
Selection.EntireRow.Hidden = True
End With
End Sub
The range select does not work (i know i do not have it in the right context), but i can't work out how to put it
anyone help please?