Hello,
I apologize for title, I don't know if its wrong.
I have the code below
That code counts according font colors in some cells.Please Login or Register to view this content.
Is there a way to stop counting an empty cell?
Thanks in advance
Hello,
I apologize for title, I don't know if its wrong.
I have the code below
That code counts according font colors in some cells.Please Login or Register to view this content.
Is there a way to stop counting an empty cell?
Thanks in advance
Nick
I thought special cells would work but it does not, so I added another perameter.
Please Login or Register to view this content.
Thanks my friend, it works!
Do you know why formula gives me #N/A?
Every time when I start the book I must double click in every cell that contains =Countcolor(...) and then enter to work.
Where is the udf located?
In a module
*I forgot to say that this situation of #n/a is not from your extra line of code, this starts happened days ago.
Sorry for my bad English..
Last edited by Immortal2014; 09-10-2020 at 08:12 AM.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, because I had this code along with other functions in the same module, I thought about trying to put the code in a separate module. After that I have no problem. I will work with it for a few days and if anything changes I will come back for information. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks