Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range) Dim bTest As Boolean Dim wb As Workbook Dim MyArray as variant If Target.Column = "3" Then bTest = Target.Row Mod 2 = 0 If bTest = True And Target.Row > 3 And Target.Row < 39 Then ' Here I need to get array containing all folder names in a directory. (Don't need their subfolders) 'MyArray = Function To Get Folder Names Back Into The Array Else: End If Else: End If End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.