| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What am I doing wrong, here?
Try Putting this into the Immediate Window:
x = 1 Do Until x = 201 Activesheet.Cells(x, 1).Formula = "=Sum(B1:B200)*Sum(C1:C200)" x = x + 1 Loop Jason Zischke "Jim May" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What am I doing wrong, here?
Sorry Jim This will work much better in your Immediate window :
Activesheet.Range("A:A").Formula ="=Sum(B1:B200)*Sum(C1:C200)" Jason Zischke "Jason Zischke" wrote: Try Putting this into the Immediate Window: x = 1 Do Until x = 201 Activesheet.Cells(x, 1).Formula = "=Sum(B1:B200)*Sum(C1:C200)" x = x + 1 Loop Jason Zischke "Jim May" wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What am I doing wrong, here?
After a good nights sleep I tried:
activesheet.range("A:A").formula = "=b1*c1" That's Cool...... "Jim May" wrote in message news:zsaJf.4713$Tf3.3542@dukeread09... 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? |
| Reply |
| 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 | |||
Linear Mode
