Hi Winon

Thanks for reply

I messed up first post a bit i think, so edited a tad to hopefully make more sense and included macro that deletes columns from "C" to ? in attached file thought it was in there first time, I'm a twit

Sorry about that.

So actually do need columns Deleted but only if there is Values in inserted columns, thing is it at the moment if it is "called" the way things are set up on my main spread sheet, it deletes the end Blue Column when there is nothing inserted between C and the Blue Column.

I need Blue column always for the Dynamic Graph to work it is part of it.

Hope makes Sense hope file now helps

Thanks again

Mike.