11 articles VBA Macro Page 2 / 2

Commonly used Excel VBA snippets

Below is collection of frequently used Excel VBA snippets I have accumulated over the years. This page will grow overtime… Feel free to comment and share! Loop through all sheets in the active workbook and print name Sub PrintSheetNames() For i = 1 To Sheets.Count ‘Print name on each cell, or replace line below and…