Macro to unhide columns, call a macro, then revert columns to previous state.

Olly, thank you so much, its working exactly as required.

I think this has been the fastest Q & A "with" a solution I have ever had.

Thank You very much.