Thread: Formula problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Len Len is offline
external usenet poster
 
Posts: 162
Default Formula problem

Hi,

After several attempts, it fails to show the correct result for the
following formula

Extract of vba code

Cells(s, 3).Formula = "=SUM(" & Range(Cells(s, 3).Offset(-1, 0), _
Cells(s, 3).End(xlUp)).Address(False, False) & ")" & "-
SUMIF(C[-2],""CF Total"",C)"

Any idea ?

thanks in advance

Regards
Len