no cells were found

  1. Z

    VBA: Run-time error 1004. No cells were found.

    Hello, I just started getting this error today. I'm building several macros that deal with Conditional Formatting (so far 20). They all use the following code to get the first empty cell in column A, which I'm using as my LastRow variable. It wasn't until I got to Sheet 7 is when this issue...
    • zero269
    • Thread
    • cell variable not defined no cells were found vba run-time error 1004
    • Replies: 15
    • Forum: Excel Questions
  2. S

    VBA No cells were found

    Hello, I tries to run a macro and a message pops up "No cells were found". The Macro runs fine until the variable dy1 is 5 (Meaning it is day 5 of the month). Some days are missing as there are weekends were no data are available. The filter returns nothing (no visible data) as there isn't day...
    • sarantip
    • Thread
    • dim dy1 no cells were found range object visibletotal
    • Replies: 9
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top