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®ion=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 )
Bookmarks