How to write a range

[dcwm]

In my Excel applications I prefer to have the columns labelled with numbers rather than A, B, C,... etc.

In plotting a chart using VBA and setting a range with an instruction such as :

Set rng = ActiveSheet.Range("A24:M27")

I should like to know how to write the range if the columns are numbered rather than lettered, please.

[mehmetcik]

Set rng = ActiveSheet.Range(cells(24,1), Cells(27,13))

[Fluff13]

You can use

Set rng = ActiveSheet.Range("A24:M27")

regardless of whether you're sheet uses A1 or R1C1 references

[Leith Ross]

Hello dcwm,

If you want to translate the A1 address to R1C1...

    Dim addx As String

        addx = Split(Range("A24:M27").Address(False, False, xlR1C1, True), "!") (1)

Returns...

    R[23]C:R[26]C[12]

[shg]

Or just

addx = Range("A24:M27").Address(False, False, xlR1C1)

[dcwm]

Thank you for that.

[dcwm]

Thank you for that