×

VBA Data Cleanup

Deleting Rows With VBA By Looping (Correctly)

Deleting Rows With VBA By Looping (Correctly)

Deleting Rows With For Each Loop Misses Rows When I first attempted to delete rows using VBA code I thought...

VBA To Determine If Duplicates Exist In Range

VBA To Determine If Duplicates Exist In Range

What This VBA Code Does There may be instances where you need to ensure there are no duplicate values within...

Swap Two Selected Cell Ranges In Excel

Swap Two Selected Cell Ranges In Excel

What This VBA Code Does Often times when I am preparing spreadsheet reports, I find myself needing to perform minor...

VBA To Insert Zeroes Into Blank Cells

VBA To Insert Zeroes Into Blank Cells

What This VBA Code Does If you do any data loading to databases and prepare/clean that data in Excel, you...

VBA To Find All Cells That Are Blank/Empty

VBA To Find All Cells That Are Blank/Empty

What This VBA Code Does I’ve had numerous instances over the years when I have needed to target blank or...

VBA To Check If Selected Cells Are Empty

VBA To Check If Selected Cells Are Empty

What This VBA Code Does Back in my early days of teaching myself how to write VBA, I found myself...

Delete Hidden Tabs or Sheets From Your Spreadsheet

Delete Hidden Tabs or Sheets From Your Spreadsheet

What This VBA Code Does This VBA code will run through all the tabs in your workbook and remove any...

Delete All Blank Worksheets In Your Excel Workbook With VBA

Delete All Blank Worksheets In Your Excel Workbook With VBA

What This VBA Code Does This is a great little snippet of code I often use whenever I am cleaning up...

Remove Blank Rows & Columns With This VBA Macro

Remove Blank Rows & Columns With This VBA Macro

Removing Blanks From Your Data A question I see asked a great deal on Excel forums is how to delete...

VBA Code To Remove Duplicate Cell Values Or Entire Rows

VBA Code To Remove Duplicate Cell Values Or Entire Rows

What This VBA Code Does Sometimes when you are cleaning up all the cobwebs of your data, you discover your...

VBA Code To Clear Cells Not Containing A Specific Word Or Phrase

VBA Code To Clear Cells Not Containing A Specific Word Or Phrase

What This VBA Code Does This brief macro code with go through each cell in a designated range and determines...

How To Remove Only Non-Formula Values From Cells

How To Remove Only Non-Formula Values From Cells

What This VBA Code Does It's that time of year again where I have been tasked to go through and...

Selecting Non-Blank Cells In An Excel Column

Selecting Non-Blank Cells In An Excel Column

What This VBA Code Does The below VBA macro code will allow you to select only the cells in a...

Delete Blank Cells Or Entire Blank Rows Within A Range

Delete Blank Cells Or Entire Blank Rows Within A Range

What This VBA Code Does Many times we as data analyzers receive data that is not so pretty (aka unorganized)....

Delete Only Grouped Columns or Rows

Delete Only Grouped Columns or Rows

What This VBA Code Does This VBA code will loop through the columns/rows on your active worksheet and delete the...

Clear Non-Formula Cells

Clear Non-Formula Cells

What This VBA Code Does Ever need to just delete content in your spreadsheet but you wanted to keep all...

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X