Dear All,
I tried to create a sub folder I got an error "Run time error 9 Subscript out of range please help how to resolved this issue
I use below VBA
I tried to create a sub folder I got an error "Run time error 9 Subscript out of range please help how to resolved this issue
I use below VBA
Code:
Sub Knop1_Klikken()
Dim sv, i As Long
Set sh = ThisWorkbook.Sheets("Data")
sv = Cells(1).CurrentRegion
For i = 1 To UBound(sv)
If Dir(sv(i, 1) & "\" & [F3], vbDirectory) = "" Then
CreateObject("shell.application").Namespace("C:").NewFolder Split(sv(i, 1), "\", 2)(1) & "\" & [F3]
sh.Range("B" & i).Value = "Folder Created"
Else
sh.Range("B" & i).Value = "Folder already available"
End If
Next i
End Sub
Attachments
Last edited: