#VALUE error when counting cells

Hello,

I use the code below to count cells with a certain fill color and when they are empty.
When i try this in an empty sheet it works perfectly but when i implement this into a big sheet where the sollution is for i get a #VALUE error.
There is no error in the range so that cannot be the problem. I know it is hard to find a sollution when the real workbook isn't provided but i realy can't upload that.
Does anyone know what can trigger this error? I added a example sheet if the cell count sollution isn't clear to anyone.

TX!

Please Login or Register  to view this content.

Hi there,

It's almost impossible to suggest a solution without access to the workbook which contains the error, but the following code might provide a workaround in cases where the error is in fact generated by the data values:

Please Login or Register  to view this content.

Hope this helps,

Regards,

Greg M