khalid79m
04-15-2010, 09:35 AM
Set IDRow = Columns(3).Find("", LookIn:=xlValues)
If Not IDRow Is Nothing Then
ThisWorkbook.Sheets("TLTDG").Rows(IDRow.Row & ":53").Hidden = True
End If
this code finds the first blank working from top to bottom and then hides the rows,
i need it to work from bottom to top , 53 to 1 rather than 1 to 53
Objective is to find last blank in column3 in values and then from that row to row 53 hide rows/
If Not IDRow Is Nothing Then
ThisWorkbook.Sheets("TLTDG").Rows(IDRow.Row & ":53").Hidden = True
End If
this code finds the first blank working from top to bottom and then hides the rows,
i need it to work from bottom to top , 53 to 1 rather than 1 to 53
Objective is to find last blank in column3 in values and then from that row to row 53 hide rows/