alienscript
06-26-2008, 06:51 PM
Hi the expert,
I hope to receive some help on copy using VB code. I'm using Excel2003.
I tried to copy only range B and E only from all sheets and append individually to Sheet("check"). That is, only copy column "Part Number" and col "JUne-08". However, it copied range B:G. How to copy only col B and E?
Thanks.
I hope to receive some help on copy using VB code. I'm using Excel2003.
I tried to copy only range B and E only from all sheets and append individually to Sheet("check"). That is, only copy column "Part Number" and col "JUne-08". However, it copied range B:G. How to copy only col B and E?
Thanks.