Out of Range Error Help-Excel

[Crystal_Wagner]

Hello.

I am hoping to get some help on an error I am receiving.

I created a code to pull data entered into one sheet(evaluation) to another worksheet(masterlist) based on a drop down selection in sheet 1(evaluation)
I am now getting a visual basic error.
**See screenshots**

Any suggestions on how to resolve.

CODE and ERROR

WORKSHEET NAMES

 

[Joe4]

If you click the "Debug" button, which line of code does it highlight?

 

[dreid1011]

If you click the "Debug" button, which line of code does it highlight?

In addition to this, it looks like your sheet name is "MasterList", not just "Master".

So this line of code:

Set wsMaster = ThisWorkbook.Sheets("Master")

Should be:

Set wsMaster = ThisWorkbook.Sheets("MasterList")

 

[Joe4]

If you hit the "Debug" button, there is a good chance it highlights the line dreid1011 commented on.
So you can see how this "Debug" button can help you - it will highlight the offending line of code, and then you can focus your attention there and confirm that everything in that line looks correct.

 

[Crystal_Wagner]

Hello.

I am hoping to get some help on an error I am receiving.

I created a code to pull data entered into one sheet(evaluation) to another worksheet(masterlist) based on a drop down selection in sheet 1(evaluation)
I am now getting a visual basic error.
**See screenshots**

Any suggestions on how to resolve.

CODE and ERROR
View attachment 118261

WORKSHEET NAMES
View attachment 118262