Dear all
suppose iam copy sheet1 columnA,B and i will paste to sheet2 columnA,C column B is hide, how to paste in columnA,C.......
Dear all
suppose iam copy sheet1 columnA,B and i will paste to sheet2 columnA,C column B is hide, how to paste in columnA,C.......
This is the 2nd question you have posted with almost no details
Keep in mind, while you know exactly what you have, what you want, and how you want it to look, we have no clue what so ever, other than what you tell us.
You cannot copy/paste sheet1 A:B to sheet2 A and C in 1 step (doesnt matter what columns are hidden) , you will need to copy/paste A to A, and then copy/paste B to C.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want e and f columns past into b and d at a time..... C column is hide...
Already told you, that cannot be done in 1 step, you will need to copy each on it's own
why not just use
B2=E2
and D2=F2
and then copy down?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks