Incrementing columns

G

grahammal

Incrementing rows in VB is of cause easy as they are numbered but how
can I increment columns as they are alphabetical?
Even if I change to R1C1 reference style, how can I relate to a cell?
Normally the reference Sheets("Sheet1").Range("A1").Select is OK
but in R1C1 format, cell "A1" becomes "R1C1". VB dos'nt seem to
recognise this.
What do I put in the same command instead of ""A1"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 3
help with dates in the past 5
dynamically reference the rows and columns as R78C15 7
Looping through columns 1
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 1
referencing ranges using R1C1 format 6
Defining an R1C1 style dynamic named range using vba 3
re-setting view of sheets so A1 is top left 2

Top