Hello, I have set up a central sheet with employee information in it and wrote macros in a few other sheets that pulls the information it needs from the central sheet. This allows me to enter the information once and then pull the information in as I need it.
However, while the macro functions perfectly on my machine, it gives a Run-time error '9' error on any other machine I try to run it on. I have checked for Add-Ins and References and everything matches. The highlighted line is the one that the debugger highlights. My first thought was that the machine didn't have access to the file opened two lines above, but when I looked, the file had opened as was intended. I am at a loss to explain this. What am I missing?
Thanks much in advance,
Scott Tucker
Bookmarks