function in vb

[Forestq]

Hi,

I have in worksheet, from row L142 until L237 function:

L142= IFERROR((SUM(I142:K142))/(K$242),"")
L143= IFERROR((SUM(I143:K143))/(K$242),"")
.
..
...
....
L237 = IFERROR((SUM(I237:K237))/(K$242),"").

Now in VB, I have a simply for loop:

For i = 142 to 237

ws.Range("L" & i ).Formula = ....

next

How to correct write formula in vba that will be working normalny in worksheet?

 

[RoryA]

No need to loop:

ws.Range("L142:L237").Formula = "=IFERROR(SUM(I142:K142)/K$242,"""")"

 

[Forestq]

I didn't know

working perfect!

thank you RoryA & pgc01!