If a value is NOT found then call another macro

[Andrewstupendo]

Hello All,
I am trying to write some coding which has two outcomes depending on whether a certain value is found or not in an absolute reference region.
The first scenario is for when the value (in this case "INVOICE NO.") is found. In this case, the macro simply ends.
The second scenario is for when the value "INVOICE NO." is NOT found. In this case, the macro calls another macro named "Tabulating_overcharges_undercharges_results_part_2".
The absolute reference region is Range("I8:I33"). Note, however, that the sheet name should NOT be listed. This macro applies to the currently active sheet - whichever active sheet the macro is working on.
Here is the coding which needs to be fixed. The coding that's not working is in bold:

Please Login or Register  to view this content.

Thanking you in advance,
Andrewstupendo

[protonLeah]

Please Login or Register  to view this content.

You didn't specify a sheet to search on....?

[Andrewstupendo]

Hello ProtonLeah,
The coding doesn't seem to be working. If you need an actual worksheet name, let's call it "8.5 x 11".
I may have left out an important piece of information. It's supposed to select the cell where "INVOICE NO." is located.
Best.
Andrewstupendo

[TMS]

Hello ProtonLeah,
The coding doesn't seem to be working. If you need an actual worksheet name, let's call it "8.5 x 11".
I may have left out an important piece of information. It's supposed to select the cell where "INVOICE NO." is located.
Best.
Andrewstupendo

An actual workbook with typical data, structure and code would be more helpful.

If you want assistance with your problem, it makes sense for you to help those who want to help you.

[protonLeah]

Please Login or Register  to view this content.

---

In your code, you introduced an undeclared variable, Rng, so VBA created it as type Variant with an initial value of Nothing. You used it without setting it (it has nothing to do with any of the previous code) so it remains Nothing.