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:
but I found that the code will also copy the format of the row of data from sheet1 to sheet2,Please Login or Register to view this content.
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
Bookmarks