Hi all,

I am using MS EXCEL 2002.
I have written a very simple script to help me copy some specific data from Sheet1 to Sheet2, using this script:
Worksheets("sheet1").Range(Cells(1, 1), Cells(1, 72)).Copy
Sheets("sheet2").Range("A" & 1).PasteSpecial
but I found that the code will also copy the format of the row of data from sheet1 to sheet2,
for example, if row 1 in sheet1 is highlighted in yellow, that the pasted data in sheet 2 will also be highlighted in yellow.

Is there any way to avoid copying the Format and the style?

Please help if you could.

Thank you

Kitty