Macro calling up UDFs unexplainably

[UlyssesBoss]

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?

[Sadath31]

I think 2nd line should be something like this

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

[romperstomper]

Your function has to be calculated as you add it to each cell, so it's logical that control will jump there. Why is it an issue?

[Colin Legg]

Also, you should use Range.Formula (or Range.FormulaR1C1), not Range.Value, to assign a formula to a cell.