could someone help me out with an array in vba?
I have about 15 words that I want to search for in an excel spreadsheet.
for each word in the array, i want to search the sheet for it, and if it finds it, add 1 to a counter. when the sheet has searched for that word, i want to assign the number to a variable, reset the number to 0, and start counting the next word.
arrays baffle me at the best of times, and as i still don't know too much about vba arrays, if someone could help me tht would be great. just about to google it, but would still appreciate any help that is on offer.
Visit my site: http://www.drybonesuk.com