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)"


...

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!...

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...