What am I doing wrong, here?
On Sheet1 (activesheet) I have numbers in Range B1:C200.
In the immediate window I've entered:
Activesheet.Range("A:A").Formula = (Range("B1:B200") * Range("C1:C200"))
When I press enter I get a run-time error 13, type mismatch
Noting gets into Col A (which shoud be the product of
B * C (according to each row.
What am I doing wrong?
|