Why use VBA? Worksheet formulae will do it

=A1*A2

and copy down

--
HTH

-------

Bob Phillips
"animal1881 " wrote in message
...
hello Xpertz!

I'm sure this question has been asked, but anyway...

I need to do some math on a cost sheet. Simple stuff:

Range(row1, column3) = Range(row1,column1)*Range(row1,column2)

What I would like to do is make column3 autoupdate whenever I change
column1 or column2. I tried using formulas like this:

Range(row1, column3).Formula = "=" & Range(row1,column1).Address(True,
True, , True)*Range(row1,column2).Address(True, True, , True)

But that only makes column3 show a zero. Worse yet, sometimes column1
or 2 is empty or a string. I noticed that if I manually enter a
formula on the complete table it works fine, only when I try it in vba
do I have a problem.


---
Message posted from http://www.ExcelForum.com/