| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Blank Column every 9 Columns
I am looking for some help with inserting a blank column
every 9 columns, the count needs to start from and include Column D and then every 9 columns insert a blank column unless the column is allready there, I have code that checks for a blank column and resizes it, I just need the portion to insert the blank column if it doesn't exist thanks Nigel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert Blank Column every 9 Columns
How far do you need to go to the right? This kind of thing is easier if you
work through the existing columns from right to left. On Mon, 14 Mar 2005 18:35:26 -0800, "Nigel Bennett" wrote: I am looking for some help with inserting a blank column every 9 columns, the count needs to start from and include Column D and then every 9 columns insert a blank column unless the column is allready there, I have code that checks for a blank column and resizes it, I just need the portion to insert the blank column if it doesn't exist thanks Nigel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert Blank Column every 9 Columns
THe other Code I uses stops at the end of the data
-----Original Message----- How far do you need to go to the right? This kind of thing is easier if you work through the existing columns from right to left. On Mon, 14 Mar 2005 18:35:26 -0800, "Nigel Bennett" wrote: I am looking for some help with inserting a blank column every 9 columns, the count needs to start from and include Column D and then every 9 columns insert a blank column unless the column is allready there, I have code that checks for a blank column and resizes it, I just need the portion to insert the blank column if it doesn't exist thanks Nigel . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert 3 blank rows wherever the date changes in column???? | Excel Discussion (Misc queries) | |||
| insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
| Insert A blank Row Everytime the date changes in column B | Excel Discussion (Misc queries) | |||
| insert a blank row after data changes in a column | Excel Discussion (Misc queries) | |||
| When sorting info in columns, can I make it insert blank line bet. | Excel Worksheet Functions | |||
Hybrid Mode
