I am having to get counts of certain strings that exist on a worksheet - it started out as one, but it is now at 3, and I foresee it growing to a few more in the near future.
Instead of me just duplicating the same syntax repeatedly to get the counts like the below - is there a way to write this and scan from an array?
Please Login or Register to view this content.
Posting an example file (desensitized) might help to get you started
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
jo15765
Try something like
Note: Evaluate method has limitation of 255 characters for its subscript.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks