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

Some videos you may like

This Week's Hot Topics