Hello,
I'm currenlty having problems getting the VBA Range.Find method. What I want in to find a number in the given range...however the values in the range are all being determined by formulas (don't know if that is causing the problem)...
Anyway, the current statement I'm using is...
Set foundCell = FuncAreaRange.Find(dblMax,Lookin:=xlValues)
where foundCell and FuncAreaRange are Range Variables and dblMax is a double variable...
Any ideas what I could be doing wrong? The statement currently returns Nothing..
Thanks in advance for any help!
ph
I'm currenlty having problems getting the VBA Range.Find method. What I want in to find a number in the given range...however the values in the range are all being determined by formulas (don't know if that is causing the problem)...
Anyway, the current statement I'm using is...
Set foundCell = FuncAreaRange.Find(dblMax,Lookin:=xlValues)
where foundCell and FuncAreaRange are Range Variables and dblMax is a double variable...
Any ideas what I could be doing wrong? The statement currently returns Nothing..
Thanks in advance for any help!
ph