Thread: count variable in range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default count variable in range
Something like this...

Application.WorksheetFunction.CountIf(range("A1:A1 00", MyVar)
--
HTH...

Jim Thomlinson


"ranswert" wrote:

What is the best way to count the number of times a variable is in a range of
cells?
Thanks
Reply With QuoteReply With Quote