Thread: Sum formula in macro returns zero
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
  
Posts: 258
Default Sum formula in macro returns zero
Hi Dan,

you can also try different approach:

rng4.formula = "=sum(" & Range("Q8:Q" & marketCount).address & ")"

Regards,
Ivan

Reply With QuoteReply With Quote