I'll play around with it a bit more and check out exescript etc. Maybe one day I'll be able to answer a question on "scraping"!
I'll play around with it a bit more and check out exescript etc. Maybe one day I'll be able to answer a question on "scraping"!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Really sorry it is giving you a time of it. I just ran my original script again and got 307 hits. I'll compile it to an EXE, and send you a link via Private Mail. If it works on your system, then it should work in VBA, and we both learn something. StanOriginally Posted by mdmackillop
Thanks Stan. All part of the learning process.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'