Hello,
Trying to assign code to comm. button on User form to copy lets say:
(sheet1, rangeB2:B21) to (sheet2, first blank row rangeB2:B21) and paste it as text value
one more question: what to be aware in case of sheets format (merged cells, hidden rows...)
To copy the data -
What information do you want regarding merged cells and hidden rows?
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlu1201,
don't know why but you're code doesn't work?
I am not so god in vba! please look at this code examples and tell me what is wrong in first one, second one is ok:
first code is involved in two sheets, second only in one sheet.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by arlu1201; 03-17-2013 at 02:32 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
When you say my code doesnt work, what do you mean?
Are you getting an error?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks