I have a problem with a full product I have inherited (20,000 lines of code with 1,300 subs).
When using the excel product everything is fine. If I change the active window (e.g. go to outlook to check mail) then the code often falls over. This is a referencing issue.
What is the best method of referencing within excel (or a declaration) to ensure the active excel instance is always referred to by the VBA.
Me.
Window
Application
A declaration?
Trying to minimise the amount of work required.