Naming a variable in a file path

[Ron]

I am trying to name a directory in a Save As path by using
a reference to a range for a directory name. This works
fine for creating a file name but not the directory part
of the path. Any suggestions?

 

[Tom Ogilvy]

mkdir "C:\My documents\ & Range("A1").Value

If you create a valid argument that would work with mkdir, you shouldn't
have a problem.