Run-time error 1004 no cells were found

**~TaC~** · 08-26-2019, 02:40 AM

Hi,

I have a macro's running a button were if data in two columns match then it removes entire row. Problem is that if there is no data then it returns the 'run-time 1004 error no cells were found'. I've tried researching this and I'm assuming its to do with the .SpecialCells command but can't figure it out.

Please Login or Register  to view this content.

Anybody got any ideas?

Thanks

**TMS** · 08-26-2019, 03:12 AM

Try

Please Login or Register  to view this content.

**huuthang_bd** · 08-26-2019, 03:14 AM

Use 'On Error Resume Next' to ignore errors

Please Login or Register  to view this content.

**~TaC~** · 08-26-2019, 03:23 AM

Perfect, thanks both.

Not what I thought and didn't even know about On Error Resume so I've learned something new

Thanks

**TMS** · 08-26-2019, 03:30 AM

You're welcome.

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

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] 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

Run-time error '1004':File not found

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