Get directory from cell

[mamero]

In my worksheet I have referenced a directory location. Eg: Cell A1 is C:\Users\NAME\Desktop\

How do I use this in a VBA by referencing the cell rather than hard coding the directory?

So for example: instead of the VBA reading:

ChDir "C:\Users\NAME\Desktop\"
It would read

ChDir "A1"

Thanks

[judgeh59]

a couple of ways could work - HTH

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[mamero]

Thanks for the reply. I put this code in but it's coming up with an error. Do I simply replace "Sheet1" with my worksheet name and replace .cells(1,1) with the correct cell? Eg: .cells("D10)?