Hi,

Thanks your quick help. Tried like u suggested but get error at
(ceels(1,1).select

if the cursor in your standard sheet is in A1 then you can delete this line,
however, I do not know why this should not work. Step through the code with
F8 to see if a new workbook is opened, remove my comments.

Can u also explain about the excel bug for columwidth amd the reason for
paste:=8 .

This is an Excel bug. Paste:=xlPasteColumnWidths simply does not work so you
have to youse paste:=8 to make the makro compatible with all versions of
excel. I do not know if this was solved in Excel 2003 or 2007.

arno