I had one more question:
The macros you supplied me with, is there anyway it can ignore blank cells(and not have them included in count)? For instance if there is a row with two keywords. and another row with the same two keywords. The max count for both rows appears as 66. the anomaly appears to only take place when there are blank cells.
was wondering if you knew what alteration to make to the previous macros to prevent this. thanks.
Bookmarks