Hey Allen,

Not to worry at all !! you are doing me the favour here so when ever you have a moment.

I also dont want to post the FTP access on this forum in public as there is almost all of the company's financial information contained in this workbook.

Thanks again !

Created 3rd party email account:
[email protected]

Why don't you just use

.To = Application.worksheetfunction .......