VBA and ChDir. Selecting a cell in a workbook

[Tinkerz]

Hi.

In VBA how can I select a cell in a worksheet the will be a directory
eg
C:\DATA

Then use the range to convert it to a string to use in Chdir

This means I can get the user to change things in the worksheet if needed

ChDir = Worksheets("Calculations").Range("K10")

But I cant get it to a string

 

[VoG]

ChDir doesn't use =

Try

ChDir Worksheets("Calculations").Range("K10").Value