ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert Blank Column every 9 Columns (https://www.excelbanter.com/excel-programming/325385-insert-blank-column-every-9-columns.html)

Nigel Bennett

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

Myrna Larson

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



Nigel Bennett

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


.



All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com