Excel Archives - Chicago Excel Classes

Add a New WorkSheet in Excel – VBA Macro Code

June 13, 2014admin

This VBA code will add a new worksheet in your Excel project. Sub AddNewWorksheet() Dim NewWorkSheet As Worksheet Set NewWorkSheet = Sheets.Add End Sub

Convert CrossTab Table to Database List Table – Excel VBA Macro Code

June 13, 2014June 13, 2014admin

If you work with databases and regular data tables you probably had a situation when someone gave you a regular Excel 2 dimensional spreadsheet that is not that useful if…Continue readingConvert CrossTab Table to Database List Table – Excel VBA Macro Code

Excel Learn

Delete All Hidden Columns and Rows – VBA Excel – Code

June 12, 2014June 12, 2014admin

This VBA code can help you delete all hidden columns and rows from your excel sheet with a click of a button. Sub hiddendelete() For lp = 256 To 1…Continue readingDelete All Hidden Columns and Rows – VBA Excel – Code