Hi guys,
In my macro gives several columns a Header and draws automaticly a box filled with a color around the Column Header/Title. Then my macro meets a specific condition and has to insert a column. This is where my problem starts.
Inserting a column is easy, but this action results in a destroyed automatic drawn box around the left Column Header, and it COPIES the Color of the the LEFT Column!
This is unwanted, The drawn boxes around the Column Headers need to stay intact, and the colors need to stay where they are. The new Inserted column needs no fill!
How can I accomplish this?
I want to copy a part of the excel sheet in here, but don't know how to do this.
Bookmarks