All working consistently now. As I have the range as a table range rather than a normal range, I had to use ListObject to get it working.

Thanks