savindrasingh
Board Regular
- Joined
- Sep 10, 2009
- Messages
- 183
I need VBA code to findout how many times a word "ACTIVE" has occured in given range. But the issue is, there is one filter applied on the next column and I want to count the occurance of given word in visible rows only. It should not count the words from non-visible rows.
Please assist with the VBA code for this.
Thanks in advance. (I will be leaving form the office, I will revert to the comments by tomorrow morning.)
Please assist with the VBA code for this.
Thanks in advance. (I will be leaving form the office, I will revert to the comments by tomorrow morning.)