VBA for folder

[Macaela]

Please help with below problem.

What i want to do is if the item is shown on the index sheet then folder will be made. if the items is hidden a folder will not be made????

Or if someone can just help me get folders to be made from the items shown anywhere without have a file path???

    'Index Populate Line 2
    If Worksheets("Generate").Range("L5").Value = "x" Then
       
        Worksheets("Index").Activate
        Rows("14").Select
        Selection.EntireRow.Hidden = False
        'Increment the numbering by 1
        Worksheets("Index").Range("A14").Value = visibilityCounter
        visibilityCounter = visibilityCounter + 1
       
       Else
       Worksheets("Index").Activate
        Rows("14").Select
        Selection.EntireRow.Hidden = True


Sub Create_Folders()

Dim sh As Worksheets
Set sh = ThisWorkbook.Sheets("Index")

'create folder where-ever document open'

Dim i As Integer

For i = 14 To sh.Range("B" & Application.Rows.Count).End(43).Row

Next i

End Sub