Thanks Mike

John, there are several ways of referencing sheets, my code will work fine on English versions of Excel, since Watersev doesn't use an English version of Excel his sheet object names (down the left hand side of the VBA IDE in the object Explorer) are not Sheet1 Sheet2 Sheet3 etc, rather they will be named in the language of the Excel installation that he is using so the objects that I reference do not exist.

You'll see that watersev uses an alternative style of referencing sheets Sheets(2), this uses the sheets collection to refer to a sheet and works irrespective of sheet name.

When I post code, I generally use the vba name of the sheet (as opposed to sheets("sheetname") or Sheets(1) which both refer to the sheets collection) since it will work after changing the sheet name property and remains constant regardless of sheet inserts and deletions, referring to the collection will not.

My suggestion above as to change the type of referencing in my code to that of the style used by watersev to remove the dependance on English Sheet names whilst using watersev's wb.

Does that clear it up any?