Oh sorry was not aware of the cross forum thing.

There doesn't seem to be a specific line in the code that returns an error. It all seems to work, and in the initial trial, there wasn't a problem. When I used the same code on 2 different workbooks (only the name was changed lines 7&8 of code), then the output columns in the new workbook displayed "#REF!" in every cell. I suspect it may be a range defining issue as I was having trouble with this before but I cannot find where.