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