+ Reply to Thread
Results 1 to 3 of 3

pasting over copied range

  1. #1
    Registered User
    Join Date
    02-19-2007
    Posts
    5

    Angry pasting over copied range

    Most probably the simplest solution to this but my heads gone blank

    B1 > F1 are the trials
    B2 > F2 are the results from each trial

    I need to keep the trial results, so when a new trial result is placed in A1 the whole range of A1 > F2 is moved right 1 cell and copied over existing cells

    \1

    so the result looks like

    \1

    This is what I tried using it will copy but not paste using A2 as activecell

    Please Login or Register  to view this content.

    Different trials are going to be used in Cells below at a later date and looped through so each row has to be row specific.

    Thanks in advance for any help.

  2. #2
    Forum Contributor
    Join Date
    07-27-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2003
    Posts
    198

    Re: pasting over copied range

    Changing ".Activate" to ".Select" fixes the problem of not doing a paste.

  3. #3
    Registered User
    Join Date
    02-19-2007
    Posts
    5

    Re: pasting over copied range

    Doh , I must have had a blonde moment

    Thanks xLJer much appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1