Thread: arrays
View Single Post
  #1 (permalink)  
Old November 2nd, 2005, 11:50 AM
ozPATT ozPATT is offline
Authorized User
 
Join Date: Sep 2003
Location: , , United Kingdom.
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default arrays

Hi again,

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.

thanks

Patrick

Visit my site: http://www.drybonesuk.com
__________________
Visit my site: http://www.drybonesuk.com
Reply With Quote