Thank you for your reply. But the use of pipes by sangmane (which i believe you are referring to ) gives me a compile error as attached. I think its because i am running a 64bit Excel and the pipe is only for 32bit? Therefore I wasnt able to ...