I've got a series of spreadsheets (see example attached) into which I need to insert YTD columns. I've written a subroutine (Insert_YTD_Columns) which starts at column 5, then shifts one column to the right and inserts a new column. This results in the new column having the same formatting as the currently selected column. When I get to the last column, the new column doesn't have the formatting of the columns to the left.
Is there a way, rather than inserting a colum to the left of the currently selected column to insert the column to the right, which will retain the same formatting? I know I can select column 5, copy it, shift to column 6, then use paste special to paste the formatting from column 5 into 6, but is there a more elegant method?
BTW, I know I could use the FillDown method to copy the formula from the top row of each of the YTD columns, but am not doing so because of this same formatting issue.