I posted recently about a technique to force a function to spill if it didn’t spill automatically. I have since learned of a much easier way. Thanks to Wyn Hopkins MVP who shared this tip with me. Below is the problem. The range A7:A10 is a spill range – it is linked to the range … Continue reading Forcing a Spill with the Magic Plus Sign