PC Review


Reply
Thread Tools Rate Thread

count variable in range

 
 
ranswert
Guest
Posts: n/a
 
      25th Mar 2008
What is the best way to count the number of times a variable is in a range of
cells?
Thanks
 
Reply With Quote
 
 
 
 
Jim Thomlinson
Guest
Posts: n/a
 
      25th Mar 2008
Something like this...

Application.WorksheetFunction.CountIf(range("A1:A100", 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 Quote
 
ranswert
Guest
Posts: n/a
 
      25th Mar 2008
Thank You

"Jim Thomlinson" wrote:

> Something like this...
>
> Application.WorksheetFunction.CountIf(range("A1:A100", 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 Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Criteria, Count If, Sum Product to get count across range Jonathan Microsoft Excel Worksheet Functions 5 9th Jan 2008 11:32 PM
Count in a variable range =?Utf-8?B?Um9uQEJ1eQ==?= Microsoft Excel Worksheet Functions 4 27th Sep 2007 08:24 AM
How to count dates within a certain range in a column with mutiple date range entries Krisjhn Microsoft Excel Worksheet Functions 2 1st Sep 2005 01:59 PM
setting a range variable equal to the value of a string variable Pilgrim Microsoft Excel Programming 2 1st Jul 2004 11:32 PM
Problem trying to us a range variable as an array variable TBA Microsoft Excel Programming 4 27th Sep 2003 02:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:37 PM.