Hi everyone! I am experiencing a #VALUE error when clearing a range of cells using a submodule. I do not get the error when I select the range with my mouse and right click "Clear Contents". Any help would be appreciated! Here is my code:
Clearing Range
Here is the formula that is throwing #VALUE error
Please Login or Register to view this content.
Here is the function I am using to count red cellsPlease Login or Register to view this content.
Please Login or Register to view this content.
Hello jdcortez,
Did you notice that most of your posted code has nothing to do with clearing cells? Why include the cell counting?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks