Hi everyone,

I'm new to forums, so I apologise at the start for any protocol mistakes I unwittingly make.

I'm also new to VBA Programming, so be gentle with me :o)

I'm writing some code to insert a column into a table in Excel 2003. The table will end up being 13 columns wide at the end of 2010, i.e. the column headers will eventually run from Dec-09 to Dec-10. I need some code to populate the new column header with a date e.g. Jan-10, using the previous column header as the starting point Dec-09 in this case.

I can't use cell references as these will change as the table grows, so I'd appreciate an alternative that will work as the table is updated each month.