This VBA code will add a new worksheet in your Excel project. Sub AddNewWorksheet() Dim NewWorkSheet As Worksheet Set NewWorkSheet = Sheets.Add End Sub
This author has yet to write their bio.Meanwhile lets just say that we are proud admin contributed a whooping 3 entries.
Entries by admin
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 you need to use the data within a database and run some queries or just make PivotTables in Excel. The Macro code below will transform […]
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 Step -1 ‘loop through all columns If Columns(lp).EntireColumn.Hidden = True Then Columns(lp).EntireColumn.Delete Else Next For lp = 65536 To 1 Step -1 ‘loop through all […]
Please, feel free to call us anytime.
Address: Chicago, IL
Locations Serving: Up to 200 miles of Chicago, IL