dj44
03-27-2018, 02:16 PM
good day,
now i know how to sequentially number, that works well
ws.Range("G7:AC7").Cells = "###"
For Each oCell In ws.Range("G7:AC7").Cells
oCell.Replace What:="###", Replacement:=i
i = i + 1
Next oCell
I wanted to know what was the mechanism for me to number in reverse
instead of 0,1,2,
G7, H7,I7
could i make
0,1,2,
Ac7, AB7, AA7 etc
start numbering from my last column to the first
well i couldnt find anything, im sure it may be something simple?
now i know how to sequentially number, that works well
ws.Range("G7:AC7").Cells = "###"
For Each oCell In ws.Range("G7:AC7").Cells
oCell.Replace What:="###", Replacement:=i
i = i + 1
Next oCell
I wanted to know what was the mechanism for me to number in reverse
instead of 0,1,2,
G7, H7,I7
could i make
0,1,2,
Ac7, AB7, AA7 etc
start numbering from my last column to the first
well i couldnt find anything, im sure it may be something simple?