I'm new to VBA coding so please bare with me.

The problem I'm having is that I have dynamic named ranges within excel and I need to reference them later in the excel document by using the indirect function. I'm aware of the problem that the indirect funciton does not work with dynamic named ranges, so I'm trying to create a workaround.

I'm looking for a VBA code for a macro that would begin by deleting any named ranges, and then create named ranges for information in column B-F and K-M (rows 3 to the final row with information in that column) based on the column header that is in the second row (ie B2).

Hopefully this will work and I can then use the indirect funciton to reference the created named ranges and just re-run the macro every time the named ranges need to include more/less information.