View Single Post
 
Old 06-11-2018, 01:08 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

When you debug, and that line is highlighted as in your picture, what's showing in the Value column of the Locals pane of the VBE for LBRS?
If it's not showing Nothing or Empty, then in the Immediate pane, type:
?LBRS.address
and press Enter. What's the result?


It would be easier to help you if you could provide a file where this error occurs - sure, desensitize the file and remove unnecessary sheets/code, but do ensure that the error still occurs before posting it here.
Reply With Quote