I want to refer to a named range in cell A1 in another cell. Simple number arrays (1, 2, 3, and 4) make up the range, which I manually typed in C3:G3 and gave the name MyArray.
Excel will display a window stating "Out of Memory" when I run my function. Is there a solution to this issue?
Range("A1").Formula2 = "=MyArray"