Incrementing Column Values

  • Thread starter Thread starter William Wolfe
  • Start date Start date
W

William Wolfe

I can increment a row value by doing an experssion i = i+1

How do I do the same for an column value and does Z roll up to AA?

Thanks,

W. Wolfe
 
I am confused. Row values are integers and columns are alpha characters.
How do I dim the value for the column?

Thanks,
 
They are only alpha values for your convenience... VBA sees them either way
depending on the method or property you are using. Here are few ways to
increment the column (I'll use a Select method to show it to you, but rarely
is it necessary to actually have to select any range in order to work with
it).

Set R = Range("A1")
R.Offset(,1).Select

or....

Set R = Range("A1")
Cells(1, R.Column + 1).Select

or...

Set R = Range("A1")
Range("A" & (R.Column + 1)).Select
 
Back
Top