Not sure it answers my question...this is what I get from the help files:

Quote Originally Posted by VBA Help
Name Statement
Renames a disk file, directory, or folder.
Syntax
Name oldpathname As newpathname
The Name statement syntax has these parts:
PartDescriptionoldpathnameRequired. String expression that specifies the existing file name and location ? may include directory or folder, and drive. newpathnameRequired. String expression that specifies the new file name and location ? may include directory or folder, and drive. The file name specified by newpathname can't already exist.


Remarks
The Name statement renames a file and moves it to a different directory or folder, if necessary. Name can move a file across drives, but it can only rename an existing directory or folder when both newpathname and oldpathname are located on the same drive. Name cannot create a new file, directory, or folder.
Using Name on an open file produces an error. You must close an open file before renaming it. Name arguments cannot include multiple-character (*) and single-character (?) wildcards.
I guess to put it in another way what I mean to do is to perform something very similiar to when you press Ctrl+Click on seperated files, then press Right-Click --> Cut....then go to the folder you want to move them to and press Right-Click --> Paste

Or like how you would format cells that are not in the same Area ....like:

[vba]
Range("A1:A3, D312, R3:U40").Interior.ColorIndex = xlNone
[/vba]

So is there something similar to this for moving multiple files? Like with one line of code?