>Since there is no data yet, can't you just make a copy of the entire sheet.
>Under the Edit menu, Move or Copy Sheet, check Create a Copy.
>
>If I'm missing something as to why you can't do that, you could select the entire sheet and copy. Then, paste special the formats to the new sheet. This would get everything except the headers.
>
>>I setup the formatting on sheet1 (no data yet, just headers and formats like font borders etc.)
>>Now I would like to create a sheet2 whith the same formatting?
>>
>>How can I do that??
>>
>>
>>Peter
Better yet can I create an XML file which I import with all the formats, headers and so forth into a sheet and then add xml data to it???


all using com


Peter