Hello Anyone:
Best wishes. I have an excel report sheet that contains 3 sets of data
in tabular form. For each set, I will find maximum value and will
highlight the cell. This maximum value is in columns b,d,f,h and j. I
am selecting each set of data as sepatre range and finding and
highlighting my cell.
----------code
range1.select
with selection
set
fndcell=cells.find(what:=val,after:=activecell,loo kin:=xlvalues,lookat:=xlpart(orxlwhole),searchorde r:=xlbycolumns,searchdirection:=xlnext,matchcase:= true).
end with
problem:
I have a max value in both 1st and 2nd set.(say 500). In my 2nd loop,
though I am selecting 2nd range, its finding the 500 max value from
range1(for set1 data) and highlighting it. The range2 selection is fine
but .find() is going outside the selection and trying to see the data
there.
what is the wrong in my code.Is the problem in the find() cluase?
Thanks in advance


--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=496471