Thread: Sum Function in Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_23_] Tim[_23_] is offline
external usenet poster
  
Posts: 2
Default Sum Function in Macro
I need to sum variable length rows in a macro. I use; Cells(ActiveCell.Row
+ 1, ActiveCell.Column).Select and then; ActiveCell.FormulaR1C1 =
"=SUM(R[-54]C:R[-1]C)".

Thanks,
Tim


Reply With QuoteReply With Quote