New, Need Vb Excel Help

Hello everyone, I am new to this site and need a little help creating a macro for excel. Every month, I have to hide a column and add a new column on the end. I need it to add the next consecutive month in the header cell for that column. I cant get it to work!!! Im not an expert so someone please help.

For example, lets say there are columns A through F. Every month I want to hide column B (which would be feburary) and add a new column into column F, which the month would change each time I ran the macro. It would be June at first, and then it would hide febuary and create July. Does that make sense.

I need it to add the next consecutive month in the header cell for that column. I cant get it to work!!!

Hi t8jones8.... show us what you've tried and hopefully we'll be able to tell you why it's not working! ;)