Thank you for the suggestion. I'll have to check into that since I definitely don't want data to be over-laid. As you can surely tell from my code, I have very little experience with vba and I really appreciate the input. Thanks!
This is the code I ended up with using the suggestions above and it does what I intended for it to do:
Private Sub CommandButton2_Click()
Dim r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13 As Range
Dim rr1, rr2, rr3, rr4, rr5, rr6, rr7, rr8, rr9, rr10, rr11, rr12, rr13 As...
Thanks all! Both methods worked (I had the time to try both). Thanks also for the information, Geoff. I like it when things work, but I also like to know why. I couldn't understand why the macro worked, but not when using with the commandbutton and your explanation makes sense.
I'm very new to VBA. I recorded a simple macro to copy information from a merged cell on one sheet and special paste it to a cell on a different sheet. The macro works fine, but when I put the code into a command button it gives me this error message: 'Run-time error '1004': Select method of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.