Excel Copy Across Macro

When you work with dynamic arrays and spill ranges you get used to the formula automatically spilling across to populate a range. When you aren’t using dynamic arrays, it can be frustrating to have to copy formulas across. Here’s a simple macro solution. In the image below I need to copy cell C3 across to the range D3:N3. This is a standard budget layout in Australia where the financial year starts in July. A one-line macro command can copy this…