What code can I use to count the number of non-blank cells in a selected range?
What code can I use to count the number of non-blank cells in a selected range?
=counta(range)
Google is your best friend!
Give this a whirl...
msgbox application.worksheetfunction.count(range("A1:D100"))
--
HTH...
Jim Thomlinson
"Lynn" wrote:
> What code can I use to count the number of non-blank cells in a selected range?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks