cntres

Hi, I use this code below to count cells based on their colour, which was coloured via conditional formatting: Sub SumCountByConditionalFormat() Dim indRefColor As Long Dim cellCurrent As Range Dim cntRes As Long Dim sumRes Dim cntCells As Long Dim indCurCell As Long...

Hi All, After days of researching through so many forums trying to find some web assistance for counting combined color cells with text, sadly, none of them helped me. This Function vba code below works fine, but I like to count cells that contains the same color & any form of text together...

I have the two functions shown below in a workbook along with several macros - the idea is that all macros, etc. are stored in a single file / workbook / location but run across several workbooks as / when required. Calling the macro's is easy enough, but how do I "execute" the functions in a...