| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the wrong? | Excel Worksheet Functions | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| wHAT AM i DOING wrong | Excel Worksheet Functions | |||
| Am I doing something wrong here? | Excel Programming | |||
| Where am I going wrong with this? | Excel Programming | |||
Threaded Mode
