programing reference worksheet

  • Thread starter Thread starter Alberto Guzman
  • Start date Start date
A

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)
 
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.
 
Back
Top