Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy/Paste in one entry (Excel 2002 sp2)

    Quite awhile ago I saw a post on a forum that had some tips about streamlining your VBA code. One of the tips showed how the separate copy and paste lines could be combined into a single line. I played around trying to figure it out, but no luck. Can anyone help, please?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Copy/Paste in one entry (Excel 2002 sp2)

    This is right from the Help:
    <hr>This example copies the formulas in cells A14 on Sheet1 into cells E5:H8 on Sheet2.

    Worksheets("Sheet1").Range("A14").Copy _
    destination:=Worksheets("Sheet2").Range("E5")<hr>

    Are you looking for anything in particular?

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy/Paste in one entry (Excel 2002 sp2)

    No, nothing particular. I'm just trying to clean up some code. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •