|
|
#3
11-16-2014, 05:42 PM
|
|||
|
|||
Thanks, Paul. This is what happens when I test the code against a test table:
The word "scanned" appears 29 times in one column of the table; your code says there is 1 occurrence The phrase "TO BE SCANNED" appears 21 times in one column of the table; your code says there is 1 occurrence Two other searches for words that occur once each in the same and other columns had no hits with this code. Not sure why this is - does the 'If .Duplicate.InRange(Rng)' code have something to do with it? I need a count of all search hits. 
|
| Tags |
| column, count, search |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro help - search for value, paste a value in another column
|
IRollman | Excel Programming | 1 | 01-14-2014 01:05 PM |
| Excel Fomula to search for a string and display value from different column | zeeshanbutt | Excel | 1 | 07-29-2012 12:48 AM |
|
Word 2007: Automatically left-justified centered table or column?
|
wornways | Word | 1 | 03-13-2012 12:18 AM |
|
Need to search a column for a macth and return a result from a third column
|
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
| How do I reference a merged cell in a multi column & row table in MS Word ('03')? | jihanemo | Word Tables | 0 | 03-18-2009 08:33 AM |
Windows XP 
Office 2010 32bit
Threaded Mode