programing reference worksheet
 

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)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

programing reference worksheet
 

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.
--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Alberto Guzman" wrote in message
...
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)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/