.Values = "=(ARLSummary!R 4C7,ARLSummary! R172C7)"
Code:
LChart.Chart.SeriesCollection.Add Source:=Trange
With LChart.Chart.SeriesCollection(2)
vbanewb14
Last Activity: May 3 '10, 02:21 AM
Joined: Apr 7 '10
Location:
-
vbanewb14 started a topic How can I edit this code to use a variable instead of specific cell references?in Visual BasicHow can I edit this code to use a variable instead of specific cell references?
Does anyone know how I can change this line of my code to reference a variable in place of "R172"? I can't use "Range" because I want to use the values in 2 cells far apart from each other.
.Values = "=(ARLSummary!R 4C7,ARLSummary! R172C7)"
... -
Help to simplify excel vba code
Hi, I am new to programming so please bear with me. I have pieced together a code which accomplished what I want it to do (creates bar graphs with a target line). Now I am just trying to simplify the code.
For example, I don't want to activate and select windows...inste ad I would like to just call worksheets directly. Also, I think the graph definitions can be cleaned, I just don't know how.
Would appreciate any guidance!... -
Trouble automating creation of charts/graphs
Hi,
I'm a newb at VBA and am having a little trouble finding help on what I'm trying to code. Would appreciate any help anyone can provide.
Basically, I am writing a macro to automate the process of creating multiple graphs. I plan to write some code (later)which will output a list of row numbers. I need this code to be able to loop through that list and create a graph for each of those rows.
I tried...
No activity results to display