Find and Select the First Blank Cell in a Column VBA
Sometimes, You may need to find and select the first blank cell or last blank cell in a column, these macros can...
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...