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)

    Thanks in advance

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!