Stuggling with Error 9

[kheman]

Hi -

I inherited a document that uses a complicated (to me at least) macro to copy and paste a cells from a file of my choosing into a templated file. Now that I've added a few entries to our drop down list form which the macro runs, I'm getting an error 'run-time" subscript out of range. When I run the debugger, it highlights the line below. Thoughts? This is honestly over my simple knowlege of macros and VBA
Option Explicit

Please Login or Register  to view this content.

[kev_]

The workbook does not contain a sheet with name "Sheet1"

This pair of values

Please Login or Register  to view this content.

[kheman]

Ughh, well there's problem #1. When I fix that, I receive the run-time error'1004'. Method 'Range of object'_Worksheet' failed

[kev_]

which line is the code now failing on?

and....please click on Edit Post and
.... comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[kheman]

My apologies. I've edited my previous post to comply with Forum rules.

Now the error is here:

Please Login or Register  to view this content.

cstrProductsCell = 'ProductList'. I've edited this list using the Name Manager to be sure it included the two new additional products. But, I'm still seeing the error.

[kev_]

This is a (very) long shot but worth a try - if it does not work go back to the original code

instead of

Please Login or Register  to view this content.

try:

Please Login or Register  to view this content.

If that does not work
-what is "RefersTo" formula for Named Range "ProductLIst"?