Worksheet_BeforeRightClick
Jan 22, 2010I am using a right click event with code that allows me to populate a name list. (“mylist”) that is used for a Data Validation drop down. This code below works great but I need for it to be used with other Target cells and there assigned name list that are within the same worksheet. When I try to repeat the code and change the range, I get an error. Do I need to assign a reference to cells selection for code or?
Here are the other target cells with there assigned name list ....