insert VARYING blank column with two intervals,

Hi Guys
I want to insert columns into my sheet. It has some columns filed say 10. I have a VBA formula which inserts one column. I cant work out how to alter it to add say 3 blank columns. I know that the 30 will need to be increased to allow for more columns and it would be sweet if this was automatic. Have not loaded an example but if you want one please ask. I got this code from "http://www.extendoffice.com/documents/excel/798-excel-insert-blank-column-every-other-column.html"

Please Login or Register  to view this content.

Any suggestions
Mark

Hi Lokesh
Hope all is well with you in India. I am in London and today the sun is shining but my office is in my basement. I appreciate your help. Thank you.

You variation works great but is not precisely what I am looking for. I have a varying number of entered columns (say 10) and I want to insert blank columns starting at column B. Your VBA inserts only once not to the end of the entered columns.
Note the existing example will insert one column for as many columns as are full.
Does this make sense or should I upload and example?

Mark

Hi Lokesh

The information you have very kindly sent me is excellent. however I have not explained correctly what I am looking for. The only difference is that I would like to be able to stipulate the number of blanks and then for the program to run till there were no more entered columns to insert between. I may have up to 100 columns between which i want to add a certain number of blanks columns. I have copied a macro into the file you made and am uploading it again. You will see what I mean. In the mean time i will go back to studying VBA. I have an awful lot to learn to be even close to these on this forum.

Mark