Adding the insertion of two new, empty, columns (A and B) at the end of an existing macro

[HarrySiers]

Hello Excel-specialists,

I would like add the insertion of two new, empty, columns (A and B) at the end of an existing macro. Anyone any idea how I can do this?

Thank you in advance,

Harry

 

[Gary McMaster]

Hi Harry,

Try adding the following line to the end of your macro:

ActiveSheet.Columns("A:B").Insert shift:=xlRight

 

[HarrySiers]

Great, Gary, thanks a lot! I will try it out and let you know if it worked.

Regards,
Harry

 

[HarrySiers]

Hello Gary, just to let you know that it worked! Thanks a lot! I posted a new thread today, maybe you will find it interesting to have a look at it. About making selections from content in Cells A1 and B1. Cheers, Harry