Add Columns without Data but keeping formulas

[eliozo]

Hello,
What is the VBA code of a button where once clicked, asks me how many columns I want to add after my last columns in my table, but they should be empty without any data but all formulas/conditional formatting/background colors or else should stay the same.
Thanks for helping asap.

 

[eliozo]

Need your help please !!!! Thank you

 

[eliozo]

to make it easier, the last column will be empty, need your help please

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

to make it easier, the last column will be empty, need your help please