How to Rebuild Data, Case Study
Sometimes we deal with data that is not standardized that we might give up, you should learn how to rebuild you data,...
Find and Format All Formulas in a Workbook
This simple macro can help find and format all cells that contain formulas. VBA Code Sub FormatFormulas() 'Step 1: Declare your Variables...
Delete Blank or Empty Columns Use Excel VBA
Blank columns can often cause problems with formulas. If you find that you are manually searching out and deleting blank columns in...
Delete Blank or Empty Rows Use Excel VBA
Blank rows can often cause problems with formulas. If you find that you are manually searching out and deleting blank rows in...
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...
How To Quickly Insert Blank Rows Between Existing Rows In Excel
Sometimes, you may need to dynamically insert blank rows between each of the existing rows into your Worksheet. Although blank rows are...
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...