Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Defining maximum value from a named range for charting purposes
Progammatically, how do I determine the maximum value of a named range in VB
to be used to define a maximum value for a chart. Thanks in advance, Barb Reinhardt |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Defining maximum value from a named range for charting purposes
maxval=Application.Max(range("A1:A20"))
Bob Umlas Excel MVP "Barb Reinhardt" wrote in message ... Progammatically, how do I determine the maximum value of a named range in VB to be used to define a maximum value for a chart. Thanks in advance, Barb Reinhardt |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Defining maximum value from a named range for charting purposes
I've figured it out, thanks. I have more to come, I'm sure.
"Barb Reinhardt" wrote: Progammatically, how do I determine the maximum value of a named range in VB to be used to define a maximum value for a chart. Thanks in advance, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
How to edit a named range | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions | |||
How do you point to a named range in linked workbooks? | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |