how to avoid copying the data that are formatted

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:

Please Login or Register  to view this content.

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