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