Gotcha! I made the change, but now I'm getting this error:
"Run-time error '-2147217865 (80040e37)': The Microsoft Access database engine could not find the object 'LabMarkings'. Make sure the object exists and that you spell its name and the path name correctly. If 'LabMarkings' is not a local object, check you network connection or contact the server administrator."
I verified the named range and its spelling, so I'm not sure why it's having trouble finding it. I tried the using a named worksheet method and did get that to work! I would like get the named range method to work, if nothing else, to not feel like I've been beaten!
Thank you so much for your help!
|