How to write a macro about Looping over collection

**Xiaojiang** · 12-29-2011, 12:23 PM

Hi everyone!
I am a new member, I have a problem with macro.
I am learning VBA myself, this is my excercise.It's difficult with me. Who can help me?
Thanks in advanced!
Please see attachment file.

**Xiaojiang** · 12-30-2011, 01:18 AM

Who can hepls me to slover this problem, please?

**gangel** · 12-30-2011, 01:22 AM

looks like someone is trying to get pplz to do their homework! lol

**Xiaojiang** · 12-30-2011, 01:53 AM

Yes, This is exactly the practice which download from internet. I am studying about Looping over collection item.
I can't it because my level is'nt enough to do it.
Who can help me to slover it? If someone help me I will learn lots of knowledge from this excercise.
Thanks so much!