Thread: Defining maximum value from a named range for charting purposes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bob Umlas
 
Posts: n/a
Default 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


Reply With QuoteReply With Quote