Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
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
Join the community of 500,000 technology professionals and ask your questions.