🧹 Remove Blank & Duplicate Rows

Excel VBA Macro #5 – Clean Your Data Automatically

This macro automatically removes:

• Empty (blank) rows
• Duplicate rows (based on full row comparison)

Perfect for cleaning large data tables before analysis or exporting reports.

---

📁 Files Included

File	Description
1.Remove_Blank_Duplicates.bas	VBA module that removes blank and duplicate rows
2.Remove_Blank_Duplicates_Demo.xlsm	Demo workbook showing data cleaning steps
3.Remove_Blank_Duplicates_Readme.md	Documentation and usage guide
4.Remove_Blank_Duplicates_Screenshot.png	Screenshot showing before/after cleaning

---

⚙️ How It Works

1. Scans the used range in your active worksheet.
2. Deletes all completely empty rows.
3. Compares the remaining rows and removes duplicates.
4. Displays a message confirming how many rows were cleaned.

---

🧠 Example Use Case

• Cleaning imported CSV data
• Removing blank rows from large databases
• Ensuring unique transaction or ID records

---

🧾 Requirements

• Microsoft Excel 2013 or newer
• VBA enabled

---

🖼️ Preview

(See the included screenshot for before/after comparison.)

---

📂 Path:
Excel-VBA-Macros/Remove_Blank_Duplicates/

License

You are free to use, modify, and distribute this code with attribution. © 2025 Data Solutions Lab. by Osman Uluhan – All rights reserved.