Hi,
I'm trying to write VBA code which will generate multiple graphs for me. I need to code to select two rows (one is constant, the other is progressing...ie. Range(A2:Z2,(A(i):Z(i)))
I'm getting stuck with this line.
Sub Test()
Dim i As Integer
NumRows = Range("B3", Range("B3").End(xlDown)).Rows.Count
For i = 3 To NumRows
Range(Cells(i, 2), (Cells(i, 2).End(x1ToRight)).Select <------Error
*****Code to generate Chart ****
Next i
I want to select (3,2) to the last value in row(3) then (4,2) to last value in row(4)...etc along with the header row(A2:Z2) then create a chart, Where Z2 is the last value in that header row.
Any idea how to create this for loop?
Bookmarks