Problem with run time error 91 in macro

[JFWeir]

Hi: I am new in my current job and have very limited experience with VB macro's in excel. One the the inventory spreadsheets I use comes up with a run time error message " Run Time Error "91" Object variable or With block variable not set.
code for the module is below. It hangs up on the yellow section.
Any help would be appreciated.

Please Login or Register  to view this content.

[Leith Ross]

Hello JFWeir,

Welcome to the Forum!

When using the Find method, you need to assign the return value to a Range variable. The Range variable will either be the cell where the data was found or the special object Nothing. Checking the result prevents errors and allows you to control the flow of the macro. I have added two Range variables to your code and their associate checks. If the PO or Supplier is not found then the macro exits.

Please Login or Register  to view this content.

[JFWeir]

The macro is now hanging up when it is trying to save the file in this section:

Please Login or Register  to view this content.

Error Message is " Run-time error '1004' Method "Save As" of object'_workbook' failed.