Calculating an Excel Value from Excel

[campbere]

I am trying to calculate the values of three cells in Excel from VB.

I have the following:

with excelcalculations
.Cells("B17&quot.Value = "=(5*5)"
.Cells("C17&quot.Value = "=Sum(C2:C16)"
.Cells("D17&quot.Formula = "=Sum(D1516)"
end with

None of these cells are getting populated using this convention. Any suggestions?

Thanks

 

[dsi]

First, the Cells object requires column and row indecies. If you want to specify cells as you have ("B17&quot you need to use the Range Object.

Range("B17").FormulaR1C1 = "=(5*5)"
or
Cells(17, 2).FormulaR1C1 = "=(5*5)"

 

[ColinC]

In the past I have had to force the cells to evaluate an expression sent from VB using something like:

Cells("A1&quot.Value = "=$E$1+$E$4"
Range("A1&quot.Calculate
Colin Chevrier
colin.chevrier@ca.jdsuniphase.com