Find Method

[Monika]

I want to start my search from the beginning of the sheet.
I am trying as:
Set tmp2 = Cells.Find(fVal, LookIn:=xlValues
SearchOrder:=xlByColumns,SearchDirection:=xlNext)
Set tmp2 = Cells.Find(fVal, LookIn:=xlValues,
SearchOrder:=xlByRows,SearchDirection:=xlNext)
where do ineed to change so that my search starts from
beginning

thanks

 

[Dave Peterson]

dim tmp2 as range
with worksheets("sheet1").usedrange
set tmp2 = .cells.find(what:=fval,after:=.cells(.cells.count), ....
end with

..cells(.cells.count) is the last cell in the range.

And by finding it after that last cell, you start with the first (usually A1).