Max Question
 

How do I get excel to look up the highest value in column d and then copy
both the value and the corresponding value in column a

Thanks in advance

Greg

Max Question
 

Hi Greg

the following code returns two variables
i - for the maximum value in column D
j - for the value in column A of the same row as i

Sub getmax()
i = Application.WorksheetFunction.Max(Range("D:D"))
j = Application.WorksheetFunction.Lookup(i, Range("D:D"), Range("A:A"))
End Sub



Cheers
JulieD


"Greg B" wrote in message
...
How do I get excel to look up the highest value in column d and then copy
both the value and the corresponding value in column a

Thanks in advance

Greg

Max Question
 

Ok thank you

Greg

Max Question
 

you're welcome - let us know if you need anything else
(ps what part of Oz are you in?)

"Greg B" wrote in message
...
Ok thank you

Greg

Max Question
 

Adelaide

Max Question
 

Perth

"Greg B" wrote in message
...
Adelaide