Thread: Creating a report by For Each...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Markus Scheible[_2_] Markus Scheible[_2_] is offline
external usenet poster
  
Posts: 95
Default Creating a report by For Each...
Hi Stef,


.Cells(3, i).Value = "=Sum(Range(sName & !
sumPremiums))"

It is the third .Cells-argument that causes my problem.



Try .cells(3,i).Formula instead of .Value...

Best

Markus
Reply With QuoteReply With Quote