here are the 3 codes i need to change to shorten execution time.
any help will be greatly appreciated.
Thanks pete, let me have a go at it and then i will let you how far i get.