| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference the 2nd and 3rd highest in range. | Excel Worksheet Functions | |||
| Highest high for a range | Excel Worksheet Functions | |||
| How can i get the 3 highest in a range | Excel Discussion (Misc queries) | |||
| Location of n-th highest value in the range | Excel Discussion (Misc queries) | |||
| Highest Value from Unique range | Excel Worksheet Functions | |||
Hybrid Mode
