Originally Posted by
cjwood555
Have you got more than one workbook open? could need modifying to:
For Each WS In ThisWorkbook.Worksheets or ActiveWorkbook.Worksheets
?
Na, just this one. And I put the module in VBA Project for this particular workbook anyway.
Stumped to be honest as my VBA skills are limited!