Hi,
We use Spill Formula, but it doesn’t recover after RefreshDynamicArrayFormulas and CalculateFormula
We have two sheets:
Sheet3 → Contains table Table1 it contains the data
Sheet4 → User function =@MY_FUNC(1) whic…...Worksheets[0] // WE NEED TO USE THIS...l , Thanks for the template Excel file, sample code snippet and...