If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
named range, data validation: list non-selected items, and new added items | KR | General Discussion | 1 | June 24th, 2005 05:21 AM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 04:44 PM |
Y-Axis maximum based on data range | Jay | Charts and Charting | 3 | January 14th, 2004 07:18 PM |
Setting Source Data to a Named Range rather than cell Range | Justin Smith | Charts and Charting | 2 | December 5th, 2003 06:56 PM |