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

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

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