I have a macro set up that when the workbook opens an input box asks for the end of week date. After you enter it in, two columns are inserted beside to other columns. The to columns next to the new columns have range names, but How do I reference the new columns added? I want to automatically add formulas and formatting to the new inserted cells.

For Instance, L9:L24 and M9:M24 have Range Names "BOB" and "TOM". If I insert to new columns to the left of "BOB" and "TOM" how could I automatically put a value in the new K9 and J9 Cells, and I want to name the two new ranges? Is this possible?

Thanks,

TJB