Run-time error 1004 no cells were found

**maitai858** · 05-27-2021, 06:50 PM

Hi everyone!

I am new to vba coding and came across an error message where I do not know how to fix. I am trying to delete the entire row within that range if the cell is blank. It was working fine until I receive error message: "Run-time error 1004 no cells were found". What is best way to get around this? Thanks in advance!

With Range("C524:C532")
.Value = .Value
.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With

With Range("C510:C518")
.Value = .Value
.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With

**TMS** · 05-27-2021, 07:27 PM

Try

Please Login or Register  to view this content.

**maitai858** · 05-28-2021, 11:17 AM

That worked, thank you so much! Appreciate the help!

**TMS** · 05-28-2021, 12:17 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Run-time error 1004 no cells were found

LinkBack

Thread Tools

Rate This Thread

Display

Run-time error 1004 no cells were found

Re: Run-time error 1004 no cells were found

Re: Run-time error 1004 no cells were found

Re: Run-time error 1004 no cells were found

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Run-time error 1004 no cells were found

[SOLVED] run time error 1004 no cells were found

[SOLVED] Alternative message box instead of run time error 1004 box no cells were found

[SOLVED] Run Time Error Message 1004 : No Cells were found

Run-time error '1004': No cells were found

[SOLVED] Microsoft Visual Basic Run-time error '1004' No cells were found

[SOLVED] Run-time error '1004': No cells were found

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions