The exact error message read "Clearcontents method of range classfailed".I've tried removing the dot from the macro & sheet name, andsimplyfying the range element but unfortunatley the same error stillpersists.....