on further inspection there seems to be something else causing a problem as its happened a few times when the worksheet is visible. So I'll have to keep digging.

Cetin already gave you the answer. It happens when nCol is greater than 26.