Thanks Martin,

PONumber1 definitely has a value, the problem seems to be copying data from Workbook1. The workbook opens but can't select, copy or paste into it.

This is my first post, is it possible to upload the example workbook?