Changing Source Path

If i need to change the fpath to another sheet & range would i just add the following;

Please Login or Register  to view this content.

If you no longer wish to hardcode the path to your files in a macro, then maybe this:

Please Login or Register  to view this content.

Remember, when you list the "path" in a cell, always end that path with a path separator:

"C:\MyFolder\MyFiles\"