Array forumla not working with .FillUp

[JPARKHURST]

My "Clean Up" has this:


<code>
Case "Working_Dispatch"
lr58 = wsClear.Cells(Rows.Count, "D").End(xlUp).Row
Set clRange = wsClear.Range("A2:U" & lr58 + 2)
clRange.FillUp 'autofill upwards to cleanse, keep formatting
</code>

A formula example I am using [array] is here:
<code>
=IF(ISNUMBER(D3),TEXTJOIN(",",TRUE,IFERROR(IF(SEARCH(E3,ShortReport!$J$2:$J$200),ShortReport!$K$2:$K$200,""),"")),"")
</code>

How can I - or can auto-fill up to retain the array 'set' without having to come back in and Ctrl+Alt+Enter?

Thanks,

Jon

 

[JPARKHURST]

Anybody have any ideas on this? Probably posted it at the absolutely wrong time on a Friday afternooN!

Thanks,

Jon