vba CODE TO FILTER OUT BLANK CELLS/GHOST CELLS and clear them

Hello,

I have big data around 50,000-100000 rows.
I want to filter out blank cells/ghost values in cells that does not hold any value but shows in count.
To do this manually I have to filter out that columns with criteria - blanks and ALT+E+A+A that range.
I have around 120+ columns and doing this manualy takes a lot of time.

I tried doing this through VBA but I'm a beginner and having issues to execute the code properly.
because my code filters out blanks and clears it but when there are no blanks in that range I do not now what to command.
I want the algorithm to be

Filter for blanks in column A,
if blanks are present in range then ALT+E+A+A/ clear out the criteria range.
If no blanks in column range then look for the blanks in column B.
Do this process till column T.


Thanks in advance.

.
See if this works. USE ON A COPY OF YOUR WORKBOOK FIRST !!!

Please Login or Register  to view this content.

It's not working.
I want the vba code to filter out the blanks in the first column and then clear out it again. if there are no blanks in 1st column then look for blanks in the next column. It should do this process till my certified range i.e, A-J

This is the manual process ...

Scroll to the very bottom of the sheet. Something like 1.4 million rows. Using the row numbers on the left, highlight the last 3 - 5 rows and leave them highlighted. Now scroll to the first blank row below your last row with data near the top of the sheet. Hold down the shift key and click the row number. All blank rows from top to bottom should be highlighted. Rt click in the highlighted area and select DELETE.

That process will clear all ghost cells below your used range. Repeat the process for all workbook sheets.

Compare the size of your files and see if the cleaned file is smaller.

On single individual cells within your used range you can try right click the cell and select CLEAR CONTENTS.

What are the characters in your so called ghost cells?