Hi,

I'm trying to input a formula into a particular cell, of which the formula involves a pre-defined variable, as below:

Range("C" & Rw).formula = "= Range("A" & Rw) * Range("B" & Rw) *100"

However, it seems to be incorrect as the error highlights on the "A" and/or "B".
I am very sure that the pre-defined 'Rw' work fine.

COuld you please help me in this formula application?

Thank you

xwxc