Sort Column Data By Double Clicking Header Cell Use Excel VBA

If you want to sort the column data in ascending or descending order by double clicking on any Excel column header, you...
 1 0

Limit Scroll Area Use Excel VBA

The following VBA code can help you to limit the scroll area for a particular worksheet. VBA code Excel’s ScrollArea property allows...
 5 0

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

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

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 0

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 0

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 0