looping through worksheet and enter formula

[CostCare]

Hi,

I'm trying to loop through a worksheet and aneter a formula in a cell.

My Code is:

Please Login or Register  to view this content.

Problem is that when i look into the cells with the inserted formula the formula is:

IF(ISERROR("L" & readRow * "C" & readRow),0,"L" & readRow * "C" & readRow). Which results ofcourse in value = 0 because of the iserror.

Please help

Regards, Bart

[spitfireblue]

Try this:

Please Login or Register  to view this content.

[CostCare]

spitfireblue,

Many thanks! This works great!

Regards,

Bart