In this article I will simply combine two different subjects – creation of formula, displaying the name of the tab and hiding a specific range per each Excel sheet.
- Concerning the formula, here it is:
- Concerning the VBA code:
For Each sheet In ThisWorkbook.Sheets
Range("AD:AZ").EntireColumn.Hidden = True
This VBA example code is one of the simplest & most used excel VBA codes, for a loop of sheets. In stead of hiding the column, it may do many other usefull things.