VBA Icon for new worksheets

  • Hi there something very strange ; when I create a new worksheet in my excel file . in the VBA browser the icon has changed to an excel icon for the new sheets whereas the old sheets were like text file icons.
    can anyone explain what it is ? my code will not run for example this fails for a sheet that looks like a Excel Icon but works great on any of the others


    Range("SHeetName").Copy .Cells(.Rows.Count, "A").End(xlUp)(2, 1)



    [ATTACH=CONFIG]73887[/ATTACH]
    Thanks in advance