MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
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
|split worksheet into new worksheets based on changing value in Column A (by means of an Excel VBA)||4||28|
|Excel: How to compare data in two columns||17||32|
|Strategy Mapping Excel WB/WS||2||27|
|IDENTIFY, THEN ADD TOGETHER AND DELETE ONE, EXCEL||3||15|