| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increase Column Heading Part 2
Starting with the 4th column, I want every third column in the forth row to
say Substation and then the number. I have set a variable that is the max substation number. I can't get this to output anything. Thanks for the help. For a = 1 To MaxSubNumber columnNum = 4 + (a - 1) * 3 Cells(4, columnnum_.Value) = "Substation " & a Next a |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Increase Column Heading Part 2
The second argument of Cells should just be columnNum surely (don't know
where the _.Value came from)? "Adam" wrote: Starting with the 4th column, I want every third column in the forth row to say Substation and then the number. I have set a variable that is the max substation number. I can't get this to output anything. Thanks for the help. For a = 1 To MaxSubNumber columnNum = 4 + (a - 1) * 3 Cells(4, columnnum_.Value) = "Substation " & a Next a |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Increase Column Heading Part 2
Thank you
"Martin" wrote: The second argument of Cells should just be columnNum surely (don't know where the _.Value came from)? "Adam" wrote: Starting with the 4th column, I want every third column in the forth row to say Substation and then the number. I have set a variable that is the max substation number. I can't get this to output anything. Thanks for the help. For a = 1 To MaxSubNumber columnNum = 4 + (a - 1) * 3 Cells(4, columnnum_.Value) = "Substation " & a Next a |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want column heading non-scrolling and rows of each column scrol | New Users to Excel | |||
| Increase column heading letters withing routine? | Excel Programming | |||
| In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
| Find Column heading and then Delete entire column | Excel Programming | |||
| Need Macro to Find Column Heading -- if none, then insert new column | Excel Programming | |||
Linear Mode
