Defining maximum value from a named range for charting purposes

[Barb Reinhardt]

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

 

[Bob Umlas]

maxval=Application.Max(range("A1:A20"))
Bob Umlas
Excel MVP

 

[Barb Reinhardt]

I've figured it out, thanks. I have more to come, I'm sure.