Hi everyone,
I'm having an issue with my macro. Here is my question.
In excel say you want to make a graph and you have range say B9:B20 can you make that range variable on the values of another cell?
So in Bx:By it would determing the range of the graph (x and y) based on cells H and I
Something like this
Range("B" & Range("H9") & ":B" & Range("I9") & ",D9" & Range("H9") & ":D" & Range("I9")), PlotBy:=xlColumns
Thank you,
George
My code:
Please Login or Register to view this content.
Bookmarks