Good day, I have a simple piece of code which should be able to fix, I'm just not sure how. Below is the code:
With the rowCounter it doesn't count to the end (I use it many times before in the code and it works perfectly), it gives the code a row number of "0". Like the following:
Please Login or Register to view this content.
=COUNTIFS(Summary!$D$52:R0C4,"=Corporate",Summary!$J$52:R0C10,"=4")
Last edited by Simone Fick; 08-28-2017 at 05:21 AM.
maybe a sample workbook to show how you came to get "0" as i cannot replicate your situation
i can understand if the formula output produces 0 but cant see how you could possibly get 0 from rowcounter
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I had rowcounter= o earlier in the code which I needed but took it out for this part, thank you. Seems like it sorted the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks