Excel VBA to select header from Sheet1 at A1 to the end of the table, and paste it to ...

Excel VBA to select header from Sheet1 at A1 to the end of the table, and paste it to another Sheets

This is the Sheet1 and I've renamed it to s1

b4Gdu.png

Then, I created 2 new sheets, name it as s2 and s3. It works.

Please Login or Register  to view this content.

Next step was to copy A1:C1 from s1, and paste it to s2 and s3 also at A1:C1

Please Login or Register  to view this content.

Unfortunately, it didn't work. Instead of pasting the content of A1:C1 from s1, it just selected from A1 to the end on sheet s2 and s3.

gWx47.png

Desired output on both s2 and s3

NXYy2.png