Something along the lines of

myMax = Application.MAX(Range("A1:M1")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cart" wrote in message
...
Forgive my intrusion on your time,

New to programming.

I need to construct a macro in excel that extracts the highest figure from
a
series of data. From this figure it calculates the 10% value from the same
data. I have used =MAX() and =MAX()*.1 I further ned to grab a time
sequence
between these two points and have all three data display in a result box
of
some sort.
Can anyone help please?
--
Regards

Cart