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
|