Worksheets("Menu").Range("C18").Formula = _
"=SUMIF(BillingHoldDetails!$A:$A,""AP
BILLING"",BillingHoldDetails!$M:$M)"

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"mniccole" wrote in message
ps.com...
Hi:
How would I change the formula below to go only the last row that
contains data instead of setting a static range?
Please help
Thanks


Worksheets("Menu").Range("C18").Formula =
"=SUMPRODUCT((BillingHoldDetails!M2:M3000)*(Billin gHoldDetails!$A$2:$A$3000=""AP
BILLING""))"