Run time error 1004 (Method Range of Object _Global failed

[ablake06]

Hello,   I am receiving a run time error 1004 (method range of object _Global failed. 

Here is the code that is tripping the error:

It does not like the range that is currently being referenced.  How do I change the range and fix this error.   Any help is much appreciated!

Aaron

[#2]

@ablake06 

In Excel, click Name Manager on the Formulas tab of the ribbon and look for the definition of SourceFilePath.