View Single Post
 
Old 09-16-2018, 12:51 PM
jrooney7 jrooney7 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2018
Posts: 23
jrooney7 is on a distinguished road
Default

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!
Reply With Quote