Hi...
I'm on a
VB mission to create a folder based on cells in
"Column A". A folder will be created when user executes
OK commandbutton which will filter data on excel worksheet.
I was successful in creating a folder with defining one range ("A1").
However, I get stuck when specifying multiple ranges. I tried "A:A",
"A1:A65353".
Any suggestions how I got stuck with a bug??
This is the code I'm using in the OK Command Button.
Dim x As String
x = "S:\Employee Folders\" & Range("A1:A65535")
On Error Resume Next
MkDir x
I'm getting this error: Type Mismatch
Thanks for your helping hand!
Myrna
*** Sent via Devdex
http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!