Set Worksheet Range

[Frankf]

I have a problem declaring a range. If I use

Please Login or Register  to view this content.

it will give me the range of the wrong worksheet. If I try to force the correct worksheet, I get "Application Defined or Object Defined error".
Could someone please look at "Employee List" Worksheet_Change sub in the section "EnterOnSubList:" and tell me what I'm doing wrong? Any other comments of my code would also be appreciated.
Thanks, Frank

[romperstomper]

To specify the sheet:

Please Login or Register  to view this content.

[Frankf]

Thanks for looking at this romperstomper. I edited it just as you suggest

Please Login or Register  to view this content.

But I get the same error 1004 "Application or Object defined error". on the line Set.....
Do you have any other ideas what might be triggering this error? I really appreciate your help.

[romperstomper]

You missed the two periods before the Cells calls that are in my post.

[Frankf]

Thank you so much romperstomper! You have no idea how frusterating debugging has been, or how long I've worked on this. Can you recommend a reference that can clarify when the period is needed, or why? It may save a lot of heartburn later.

[romperstomper]

The periods are needed for the Cells and Range calls to make them 'belong' to the Sheets("Sub Contractor List") object. If you didn't use the With...End With, then you would have to write:

Please Login or Register  to view this content.

As you can see, the With statement makes it a lot neater.