Thanks pj, thats a good suggestion, but the end user will already have at least one other workbook open before the macro is ran, so the Index number would be variable.

Thanks