+ Reply to Thread
Results 1 to 2 of 2

Making scipt paste values on a new line every time?

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    Melbourne, AU
    MS-Off Ver
    Excel 2003
    Posts
    12

    Making scipt paste values on a new line every time?

    Hey guys,
    Just trying to get the following code to work, I need it, rather than counting columns and placing the values on a new row in a single column, to actually paste the values across the same row, and go across separate columns.

    I cannot figure out how to change the code to have it do this.
    So far it only writes 2 lines, then stops, and overwrites the second line.

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Making scipt paste values on a new line every time?

    try the following change:-

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 - Paste Values with Paste Transpose at the same time
    By phillyfilly in forum Excel General
    Replies: 3
    Last Post: 11-05-2013, 04:23 AM
  2. [SOLVED] Excel 2010: Run-time error at .Chart.Paste line within With statement (works on 2003/2007)
    By JohnMcCallum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2012, 11:53 AM
  3. [SOLVED] timesheet problem with making certain time values work.
    By shawnf711 in forum Excel General
    Replies: 4
    Last Post: 05-18-2012, 09:43 PM
  4. Making a line chart showing increases in data usage over time
    By rebecca08 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2008, 04:55 PM
  5. adding values from a date to a time line.
    By jcarstens in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2008, 04:44 PM

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