Hi there,

I'm running a Macro that fills in a UDF formula:

' CPC
Worksheets("Report by Day").Range("F7").Value = "=IFERROR(CPCDATE('Report Config'!$B$4,'Report Config'!$D$4,E7,H7,Data!F:F,C7,Data!BK:BK),0)"

Worksheets("Report by Day").Range("F" & LastRow & "").Value = "=IFERROR(J" & LastRow & "/E" & LastRow & ",0)"

My procedure code works fine when I run it with my UDFs commented out but when I run it without the comment block. It jumps from my procedure to the UDF and then just loops through that continuosly.

Is there any way to get around this?