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
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("A1:A20"))
Bob Umlas
Excel MVP
"Barb Reinhardt" <[email protected]> wrote in message
news:[email protected]...
> 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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks