TheAnswer
12-12-2010, 07:03 PM
Set subValue = Workbooks("bbca volume report 2010_may_team.xls").Worksheets(sheetActive).Columns("A"). _
Find(What:=subArea, After:=Columns("A").Cells(1, 1), _
LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
With this, i am able to search for value in a column from top row to bottom row. But is there a way to search from the bottom row to the top row instead?
Find(What:=subArea, After:=Columns("A").Cells(1, 1), _
LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
With this, i am able to search for value in a column from top row to bottom row. But is there a way to search from the bottom row to the top row instead?