programing reference worksheet

[Alberto Guzman]

I have a question is just the sintax of the second part of this statment
:
Catalogo is aworksheet, Estimate is a worksheet
take the values from Estimate to Catalogo, programing, once is
calculated could vary, just is the sintax for the Estimate I dont know
if is & "Estimate" & or .....


Worksheets("Catalogo").Cells(IIRowC, 3).Value = "=SUM (" &
Estimate!(StartTotalCell) & ":" & EndTotalCell & ") + SUM ( " &
StartTotalCell & ":" & EndTotalCell & ") * " & FacIndi & "/ 100"

File Attached: http://www.excelforum.com/attachment.php?postid=320105 (duda.txt)

 

[Harald Staff]

Hi

1) It should say Formula, not Value, since that's what you're entering. Excel will
mobilize her empathy and correct it, but still ...

2) Keep the sheet name in the formula sting, do not treat it as a variable:

Worksheets("Catalogo").Cells(IIRowC, 3).Formula = "=SUM (Estimate!" & _
StartTotalCell.Address & ":" & EndTotalCell.Address & ") + SUM ( " &

.... assuming StartTotalCell is a range, not a number that is.