Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incrementing Column Values
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incrementing Column Values
Same way, and yes.
"William Wolfe" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incrementing Column Values
I am confused. Row values are integers and columns are alpha characters.
How do I dim the value for the column? Thanks, "Bob Umlas" wrote in message ... Same way, and yes. "William Wolfe" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incrementing Column Values
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 -- Rick (MVP - Excel) "William Wolfe" wrote in message ... I am confused. Row values are integers and columns are alpha characters. How do I dim the value for the column? Thanks, "Bob Umlas" wrote in message ... Same way, and yes. "William Wolfe" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling In A Column With Incrementing Values ? | New Users to Excel | |||
Incrementing values | Excel Discussion (Misc queries) | |||
How do I Incrementing Cell Reference Values by 7? | Excel Discussion (Misc queries) | |||
Incrementing by 1 in every other column | Excel Worksheet Functions | |||
Dragging & incrementing cell values | Excel Worksheet Functions |