see response to your later posting in a new thread.

--
Regards

Roger Govier


"mniccole" wrote in message
oups.com...
HI:
Can you tell me how to loop to the end of the data range without this
being static?
Please

numrows = Range("A2", Range("A2").End(xlDown)).Rows.Count
Range("A2").EntireColumn.Select

For x = 1 To 3000

Thanks so much

Bob Phillips wrote:
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""))"