Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change range name
I have a series of dynamic range names (i.e.. PX1, PX2, PX3, PX4, ect). I
want to set up a loop to use each range name. I tried something like this which does not work: Dim RngNbr As Integer, iRow As Integer RngNbr = 1 Sheets("HistData").Select 'Select range PX1, PX2, PX3, PX4 by changing the value of RngNbr Set pxRge = Range("PX & RngNbr") ActiveSheet.ChartObjects("Chart 41").Activate With ActiveChart.Axes(xlValue) .MinimumScale = 0.97 * Application.WorksheetFunction.Min(pxRge) .Crosses = xlCustom .CrossesAt = 0 .ReversePlotOrder = False .ScaleType = xlLinear End With Any ideas? I would also like the select different charts with a similar method. -- Al Eaton |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
Change the Range refering to a Name | Excel Discussion (Misc queries) | |||
How do I change a range name back to the underlying data range? | Excel Worksheet Functions | |||
How do I change the range? | Excel Worksheet Functions | |||
how to change range in VBA? | Excel Programming |