If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to increment column
I want to start at column 20 and incrment by 1 and insert
a heading for each column - all via a macro. I can capture the column index but I can't seem to increment to the next column. Help Glen |
#2
|
|||
|
|||
How to increment column
To make a heading for columns 20 to 25:
Sub MakeHeads() Cells(1,20).resize(1,6).Value = array("Head1","Head2","MyHead","Head4","Head5","Co l25") End sub wrote in message ... I want to start at column 20 and incrment by 1 and insert a heading for each column - all via a macro. I can capture the column index but I can't seem to increment to the next column. Help Glen |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Page Break vs Column Break | DreAndre | Page Layout | 8 | June 23rd, 2004 02:02 PM |
Display column 4 in combo box AfterUpdate | Bradley C. Hammerstrom | New Users | 2 | May 27th, 2004 06:29 PM |
Adding an Offset to a Column Value | SidBord | Worksheet Functions | 2 | April 17th, 2004 07:21 PM |
Increment column value based on insert string | A.W.J. Ales | Worksheet Functions | 1 | April 15th, 2004 02:44 PM |
"Matching" column A's values in column B | Chris.F | Worksheet Functions | 0 | January 12th, 2004 02:24 PM |