Thanks for making that change for me - it works perfectly. And I greatly appreciate the work that you have put into this for me.

I have however tried to use it to draw data from a different file - 'Income Analysis.xlsx' but the Registry box didn't provide me with all the different 'sheet' options. I discovered that it just listed the sheets where the sheet name had only one word. Mine was called 'Bank Credits'. Is that something that is built into the coding somewhere? Or can it be altered to show all sheets including that that have a space in the name? Or maybe that's bad designing on my part?