Change file path name in VBA code based on files location

[klunker]

Hi all,
I have the following code written but I'm wondering if it's possible to modify this to change the red line to update to the path that the workbook is saved in? Meaning that User1\Folder1\ would change but [Workbook1.xlsm]Sheet1'E1 would always be the same. Thanks for any help you can give!

Please Login or Register  to view this content.

[Kenneth Hobson]

Please Login or Register  to view this content.

[klunker]

Thanks Kenneth,

Worked great.