Row Formatting

[Aaron Murray]

If a cell in column IV(last column) contains a value and I
insert new columns the value in IV predictably disappears.
If a formatted row is extended to column IV and I then try
to insert columns nothing happens or, when a value exists
somewhere in column IV and I'm running a macro that
inserts columns, an error message appears.
Is there a setting that allows excel to insert the columns
even if it means trashing values or formatting in last
column?
Aaron Murray

 

[Dave Peterson]

I think your first statement is incorrect. Excel won't let you insert a new
column and have column IV just disappear (with something in IV).

You could always wipe out column IV whenever you want (scary, but you can do
it).

with worksheets("sheet1")
.range("IV1").entirecolumn.delete
'do your insert column
end with