[RESOLVED] Excel VBA - Multiply Function

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

try like
Range("C" & Rw).Formula = "=" & Range("A" & Rw).Address & " * " & Range("B" & Rw).Address & " *100"

but it may be better to use r1c1 notation

Hi

Many thanks

xwxc