Solved: Reverse find

[khalid79m]

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/

[mdmackillop]

Check the VBA Help on the Find function. xlPrevious is what you are after.

[khalid79m]

thanks