Defining maximum value from a named range for charting purposes

's Computer Specifications

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

's Computer Specifications

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

"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:8D895101-FE75-4600-84B2-(E-Mail Removed)...
> 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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking up a returned value defining a named range	DRC	Microsoft Excel Misc	2	23rd Mar 2010 02:49 PM
Defining a custom-named Range across several worksheets	=?Utf-8?B?U3ZlbiBIZXJyZW1hbnM=?=	Microsoft Excel Worksheet Functions	3	23rd Oct 2007 12:23 PM
Defining Named Range for Lastrow in a specific column	=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=	Microsoft Excel Misc	5	9th May 2007 08:55 PM
Defining series range for named range	=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=	Microsoft Excel Programming	1	3rd Aug 2006 09:00 PM
Defining a named range for a dynamic result set	=?Utf-8?B?S2VpdGggQi4=?=	Microsoft Excel Programming	2	19th Apr 2006 10:26 PM