Ads

Friday, 3 October 2014

Insert Rows & Columns-Macro Coding

Below is the code to insert Row by VBA in excel

ActiveSheet.Range("b1").EntireRow.Insert

Below is the code to insert Column by VBA in excel

ActiveSheet.Range("b1").EntireColumn.Insert

No comments:

Post a Comment