View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Stef Stef is offline
external usenet poster
 
Posts: 27
Default Creating a report by For Each...

Hi Markus!

I tried that without success. Thanks anyway.

Stef

"Markus Scheible" wrote:

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