Thread: Summing a Column of Variable Length
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default Summing a Column of Variable Length
Sub Sum1()
Dim iEnd As Integer
iEnd = Sheets("Master").Range("D1").End(xlDown).Row
Sheets("Monthly").Range("Z1").Formula = "=SUM(Master!D1:D" & iEnd &
")"
End Sub

Hth,
Merjet


Reply With QuoteReply With Quote