How to count cells with same fill colour containing same text...JoeMoe

H

Howard

Hi JoeMoe

Google search failed to find this ref.

REF:
JoeMoe from the newsgroup
"How to count cells with same fill colour containing same text"

I copied your solution to this post some time ago but am having trouble making it work. Seems the instructions from "...your post no. 4" did not copyvery well into my Excel sheet for some reason. Although they seem pretty complete I believe I have "copy typos" preventing me from getting it to work.

These are the names of the two subs and one function.
Sub Split_Teams()
Sub CountByFillColor()
Function CountByFillColor2(R As Range, sTxt As String, sColor As String) AsLong

Could you use the cc: to zip me a copy of a working workbook of this?

Thanks and Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data 1
Word macro that can call cells out of Excel for a find and replace 0
How to count colour and content of fields? 1
Macro to Select text from a point given to a specific word 2
How to delete ALL cells containing the same data --- REVISED 0
count shaded cells with a gradient fill 3
Advice on multiple macros, same code just a different column 9
Inaccurate count with code 6

Top