Thread: Using the Lastrow variable in a Count/Countif formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default Using the Lastrow variable in a Count/Countif formula
maybe:

Range("D1").Formula = "=COUNT(""M5:M" & bb & """)"
'or
Range("D1").Formula = "=COUNT(""M" & 5 & ":M" & bb & """)"

Trevor Shuttleworth wrote:

John

try: Range("D1").Formula = "=COUNT(""M5:M"" & bb)"

Regards

revor

"John" wrote in message
m...
Here's what I'm trying to do:

1. Find the lastrow with data in it:

bb = Cells(Rows.Count, "B").End(xlUp).Row (OK)

2. Next use variable bb as part of a COUNT formula in cell D1:

Range("D1").Formula = "=COUNT("M" & 5 & ":M" & bb)"

The error I receive is:

Compile error -- expected End of Statement

Please help

Thanks
John

--

Dave Peterson

Reply With QuoteReply With Quote