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,...
1

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...
0

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...
5

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...
3

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...
12

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...
5

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...
7

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...
2