Can you use array formulas in VBA?
Can you use array formulas in VBA? To use the MonthNames function in a worksheet, you must enter it as a 12-cell array formula. For example, select range A2:L2 and enter =MonthNames(). Then press Ctrl+Shift+Enter to enter the array formula in all 12 selected cells. You can also pick out a single month from the […]