I have a spreadsheet with a row of about 35 HKSE ticker codes ( 0307.HK ). I have a cell that has this formula:

=RCHCreateComment("http://chart.finance.yahoo.com/c/0b/3/0307.hk?lang=en-US&region=US&width=300&height=180",99,200,150,1)

which uses the smf_addin to produce a small chart which I use to see the 1 year trend of the stock at a glance. I manually type in the next ticker code to see the next chart.

I'd like to automate the process but being a super novice I've had no luck producing a macro and have even less knowledge of VBA.

If it is a trivial matter could someone please show me how to do this ? Or suggest a site or ebook where I might learn how ?

I'd really appreciate any help .

Thanks very much.

Ralph ( ralph.bagwell$gmail.com )