Unhide All Rows and Columns
This simple macro automatically unhides all rows and columns for you. VBA Code Sub UnhideAll() Columns.EntireColumn.Hidden = False Rows.EntireRow.Hidden = False End […]
Insert Blank Rows Between Existing Rows In Excel VBA
Sometimes, you may need to insert blank rows between each of the existing rows into your Worksheet. Although blank rows are generally […]
Loop Through a Range of Cells
One must-have VBA skill is the ability to loop (or enumerate) through a range of cells. If you do any serious macro […]
Creating, Selecting and Formatting Named Ranges Via VBA
Creating Named Ranges Creating a named range via VBA is much less involved. You can directly define the Name property of the […]
Formatting a Range of Cells In Excel VBA
Formatting Cells Number General Range("A1").NumberFormat = "General" Number Range("A1").NumberFormat = "0.00" Currency Range("A1").NumberFormat = "$#,##0.00" Accounting Range("A1").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)" […]
Select a Range In Excel VBA
One of the basic things you need to do in Excel VBA is to select a specific range to do something with […]
Highlight the Active Row and Column Use Excel VBA
When you looking at a large worksheet with numerous data, it would be nice if Excel automatically highlighted the active cell row […]
Zoom In and Out in Worksheet on Double-Click
Sometimes, if you want to zoom in and out in a worksheet, you need to have a finger on CTRL and the […]