VBA – Hide specific range per each sheet + formula for tab

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:

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.

Enjoy it!