Thanks for the comment, looking again , I realise that my solution is incomplete for what was required, however the basic principle of minimising the number of accesses to the spreadsheet is something I have used many times to speed up macros.Originally Posted by SamT
Not bad for a first time poster
Welcome aboard.
Reply With Quote