| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incrementing columns
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"? -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=484299 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incrementing Rows and Columns | Excel Discussion (Misc queries) | |||
| Incrementing Rows in columns | Excel Programming | |||
| incrementing columns in a loop | Excel Programming | |||
| Next not incrementing | Excel Programming | |||
| Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
![grahammal[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
