Macros - adding columns and deleting columns

[ds0919]

Hi, I am new to this forum and fairly new to macros in Excel 2010. I am trying to create a macro to do the following:

- Delete column C
- add 2 new columns (between E & F and between G & H)
- Change the font for the entire worksheet

So far the only part that I can get to work is the font change. When I try to delete the column, the entire spreadsheet contents disappears. (I am selecting the column by clicking on column E, then I select from Home tab, the Cells group, the Delete icon.)

When I attempt to insert the 2 columns (home tab, Cells group, Insert cells with column F selected) It moves the entire spreadsheet over to column K.

Any help would be greatly appreciated!!

[mshale]

Please post the code that you have. Remember to use the code tags - it's the one that looks like the pound/hash symbol (#).

[ds0919]

Is this what you were asking for?

Please Login or Register  to view this content.

[mshale]

Well, you got half of what I wanted :P. When you post code in the future, click the # button right above where you type your post, then paste your code between those tags.

I see no flaw in your code. For me, it does what you want it to do. All I did was clean it up a bit:

Please Login or Register  to view this content.

[ds0919]

I'm not sure what you did, but it works now. Many, many thanks to you!!!!!!

[getcarter15]

Hi

just wanted to add to this thread in case anyone else has the same problem as the OP, like I did - I was using a macro to delete a single column but it was deleting all data in the worksheet. I discovered that for some reason, all of the cells on the sheet were merged, even though it didn't look as if they were. Maybe it was because the spreadsheet I was using was directly exported from a web application, which I suspect had something to do with it. Anyway, starting the macro by selecting all cells and un-merging solved it for me
.
carter