I have a problem declaring a range. If I useit 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".![]()
Set RangeName = Range(cells(R,10),Cells (R,NextCol))
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
Bookmarks