Hi, this is in worksheet and works okay until i click out of the worksheet into another one, when i go back in the formulas have all gone to #value.. i have to go into tools/options/calculate/calculate sheet to get them back - what is doing this please because it stops all my lookup references fromworking once the data is decalulated (for want of a better word )
the code that i use in the cells is
Code:
Function ConcatDay(rng As Range, item As String, Optional dte = True)
Application.Volatile
For Each ce In rng
If ce <> "" And rng.Parent.Cells(3, ce.Column) = item Then
If dte Then
holder = holder & Format(ce, "d-m") & ", "
Else
holder = holder & ce & ""
End If
End If
Next ce
ConcatDay = Left(holder, Len(holder) - 2)
End Function
the code that i use in the cells is
Code:
=concatmth('Group Formula'!$C6:$IR6,D$2)