Need help! To delete rows in a spreadsheet

[Yuly Byrow]

Hi There,

I have a spreadsheet with alot of rows approx 56000. I need to delete the (entire) row when a cell in column c is blank.

I have never used macros before (at least not vba ones) and I'm unsure why it isnt working. The script I wrote for some reason is deleting rows when a cell is not blank. Any help would really be appreciated!

Thanks!

Yuly

 

[Aurelie]

Hi Yuly,

Did you try to filter on blanks and delete all rows, then to remove the filters to get a table without blank rows? If you need a macro based solution, you can record a macro following these steps and then fine tune following your needs.

Does it help?

 

[Marc L]

​

Hi Yuly,​

​

I know why your code is bad (logical conception error) but you have to post it to confirm that​

and to get a good return code …​

​

Aurelie (french spoken ?) there is a direct way with no filter in VBA.​

But for sure it's the easy way with the Macro Recorder …​

​

 

[Luke M]

This is what the script needs to look like. Note that I slaved away at writing this.

Sub DeleteBlanks()
ActiveSheet.Range("C:C").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

 

[Marc L]

​

This is the direct way mentioned above …​

​

 

[Luke M]

​

This is the direct way mentioned above …​

​

Sorry Marc, guess I gave away the answers.

 

[Marc L]

​

You're welcome !​

​

I was just waiting for an answer to explain why … before posting the code …​

​