Good day,
I am attempting to build a countif to count each cell, in range of cells in the same row (Myrange), that is the maximum for rows i-n to i+n in each cell's respective column. Currently the function below returns a 0 value in all application uses for any given row range and an n. Any assistance will be appreciated.
Please Login or Register to view this content.
You are using MAX property incorrectly. The code you are using would check only 2 cells. This is how it should be used-
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
I see. I assumed that it would compute as a range similar to using the max function in the application. I see now even when using application functions in vba, I need to explicitly state a range.
Thank you for the help!
Yup.
Actually the best way to debug a function is to convert the function to a macro like this (in a separate rough workbook) and then use F8 to run it line by line.
Please Login or Register to view this content.
Did not think of that. Thanks, this is quite helpful.
Glad to know that helped!
If your query is resolved please take a moment to mark this thread as solved from the "Thread Tools" at the top of this page.
You can also click on "Add Reputation" below my post if that was helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks