View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Strange Named Ranges

I'm using Excel 2007 and am getting some compatibility errors when saving a
file as a .xls file. Anyway, I'm checking the named ranges and when I list
them out using some code I prepared, I have a bunch of names that look like
this:

Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.Cols
Defect Summary'!Z_856B468A_867D_4C40_9C74_F4AE145D3584_.w vu.PrintArea
Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.Cols
Defect Summary'!Z_BDF4DCB3_66F4_468C_B839_B4DBA2393C10_.w vu.PrintArea
Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.Cols
Defect Summary'!Z_D7C000CA_0BF8_42CF_8BE1_4F5288B469FF_.w vu.PrintArea


I do have a worksheet 'Defect Summary', but I don't know where the Z_ ...
part came from. I have another handful that apply to another worksheet.
Can someone shed some light on the source of these? They also don't display
in the name manager within Excel.

Thanks,
Barb Reinhardt