software

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

maxval=Application.Max(range(quot;A1:A20quot;))
Bob Umlas
Excel MVP

quot;Barb Reinhardtquot; gt; wrote in message
...
gt; Progammatically, how do I determine the maximum value of a named range in
VB
gt; to be used to define a maximum value for a chart.
gt;
gt; Thanks in advance,
gt;
gt; Barb Reinhardt
I've figured it out, thanks. I have more to come, I'm sure.

quot;Barb Reinhardtquot; wrote:

gt; Progammatically, how do I determine the maximum value of a named range in VB
gt; to be used to define a maximum value for a chart.
gt;
gt; Thanks in advance,
gt;
gt; Barb Reinhardt