For Each advice

[Luke777]

Hi All,

Quick question regarding use of For Each

If I'm performing an operation that looks through some data in A:A and does something to each String in A - is the operation performed on each individual data entry?

I'm asking because in my data, A1:A10 contain the same values, A11:A15 contain another set of the same values - so would using for each perform the same operation multiple times on the same value as it appears multiple times in A1:A10

Thanks

 

[queuesmef]

depends on your code....but it should iterate the same. Yes

 

[Luke777]

Sorry, I should add that I was thinking of making a scripting. Dictionary out of the values in A:A - so I suppose I should be asking if the same 'word' will repeat itself in the dictionary because it appears in A:A multiple times

 

[RoryA]

Not if you use it as the key, since keys are unique.