Hello
Again I ask your help. Only this way I can learn some VBA.
I have a userform with an option button. When I click this button I want to do this:
copy from Sheet1, from row 5,from column A to D, down until last cell from column A is empty; I want to paste this to Sheet2 (which is the active sheet), paste from A5;D5 down.
How does the userform picture in the copy-paste? Do you want the copy paste to be done only when the option button is clicked?
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]
Maybe something like this?
Please Login or Register to view this content.
This I know.
But I want to select only cells wich are not empty
Like if A12 is empty, copy from A5 to D4
I'm sorry, but I don't understand what you mean.
Just copy from Sheet1 A5:D5 to last row which is not empty to Sheet2 same A5:D5
I found something but still doesn't work:
Please Login or Register to view this content.
Oh, now I think I know what you mean. There are some syntax mistakes in the code you posted, try this:Is it working?Please Login or Register to view this content.
edit: this code does the same but without selecting:Please Login or Register to view this content.
Last edited by RHCPgergo; 01-21-2013 at 07:24 AM. Reason: more efficent code added
Thank you.
It' working perfect.
I was thinking about something else, more complex, which doesn't needed here; something like:
"... do until Last Row="<>"
[SOLVED]
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks