Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sean614

    Copy/Paste merged cell using command button

    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!
  2. sean614

    Copy/Paste merged cell using command button

    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...
  3. sean614

    Copy/Paste merged cell using command button

    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.
  4. sean614

    Copy/Paste merged cell using command button

    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...

Part and Inventory Search

Back
Top