Posts by max_max

    I don't understand how R1C1 formulas work

    Code
    1. For i = 2 To 6 'Headers to be added
    2. ActiveChart.SeriesCollection(i).Name = "=Table!R1C" & i + 1
    3. Next i
    4. ActiveChart.SeriesCollection(1).XValues = "=Table!R" & lr & "C1:R" & lw & "C1"
    5. End With

    Hi to all.

    I found this macro in this forum:



    but I can't adapt it to my file.

    I hope I explained myself

    max