Thread: Mixing Absolute and Relative Reference in a Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Mixing Absolute and Relative Reference in a Formula
Yup - misread...thanks for the correction.

In article ,
Tom Ogilvy wrote:

wouldn't it be

With Range("A" & Rows.Count).End(xlUp)(2)
.Formula = "=SUM(A15:A" & .Row - 1 & ")"
End With

Reply With QuoteReply With Quote