I have written macro which have sheets 6 and when file which i get have sheet 2 only,when i run maco on file having sheet two i get error as SUBSCRIPT OUT OF RANGE, and doesnt run further macro and after having code for sheets i have written code for deleting macro,because of this error am not able to delete macro also