Highest Value In A Range
 

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec

Highest Value In A Range
 

Place this on cell A6

=MAX(K:D)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Alectrical" wrote:

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec

Highest Value In A Range
 

Thanks for your reply Michael,

Sorry, but forgot to mention that I want this to work on the click of a
button.

Thanks Again Alec

"Michael" wrote:

Place this on cell A6

=MAX(K:D)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Alectrical" wrote:

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec

Highest Value In A Range
 

Try this in your click event of your button
Range("A6").Formula = "=Max(D:K)"
"Alectrical" wrote:

Thanks for your reply Michael,

Sorry, but forgot to mention that I want this to work on the click of a
button.

Thanks Again Alec

"Michael" wrote:

Place this on cell A6

=MAX(K:D)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Alectrical" wrote:

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec

Highest Value In A Range
 

Attach this to your button

Range("A6").Value = WorksheetFunction.Max(Range("D:K"))


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Alectrical" wrote:

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec

Highest Value In A Range
 

Thanks Mike

"Mike" wrote:

Try this in your click event of your button
Range("A6").Formula = "=Max(D:K)"
"Alectrical" wrote:

Thanks for your reply Michael,

Sorry, but forgot to mention that I want this to work on the click of a
button.

Thanks Again Alec

"Michael" wrote:

Place this on cell A6

=MAX(K:D)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Alectrical" wrote:

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec

Highest Value In A Range
 

Thanks Michael

"Michael" wrote:

Attach this to your button

Range("A6").Value = WorksheetFunction.Max(Range("D:K"))


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Alectrical" wrote:

Hi

How can I find the highest value in the range "D:K" and place that value in
a cell ie "A6"

Thanks
Alec