LinkBack URL
About LinkBacks
Hello,
I need help in creating VBA which would count cell value not equal to "Open" and "Closed"
What am i missing ?
Range("D5").Select ActiveCell.FormulaR1C1 = "=COUNTSIF(Dump1!C2,""<>Open"",""<>Closed"" )"
Thanks,
Shiva
Hello,
I need help in creating VBA which would count cell value not equal to "Open" and "Closed"
What am i missing ?Range("D5").Select ActiveCell.FormulaR1C1 = "=COUNTSIF(Dump1!C2,""<>Open"",""<>Closed"" )"
Thanks,
Shiva
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks