if not c is nothing then

  1. V

    VBA - If Nothing Found, then Put Text into the cell

    Hello everyone, I have a macro right now, that has a "Master" worksheet, and several Accounts worksheets. It currently finds the word "Dividend" and "Interest" in the Accounts worksheets. Then it will find the amount of the Dividend or Interest, and place the amount/# in the Master worksheet...
  2. NicholasP

    For/Each w/Find optimization

    OK...one more piece of code is running super slow...I'm stepping through a range cell by cell (which I DON'T like, as the range is ~7000 cells) and for each cell I'm looking it up in a different range that contains lookup values that replace the abreviations in the range with 7000 cells...Any...

Watch MrExcel Video

This Week's Hot Topics

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
Top