+ Reply to Thread
Results 1 to 3 of 3

Copy/Paste across worksheets doesn't work

  1. #1
    Forum Contributor
    Join Date
    08-31-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    204

    Copy/Paste across worksheets doesn't work

    Hi all, I am trying to do something rather easy and was hoping there is a good solution to below. Any thoughts would be greatly appreciated! thanks so much

    So basically I have 2 spreadsheets:
    Data.csv (my data with 20 header columns)
    Summary.xls (I only need 10 columns from data.csv)

    I am pulling 10 random columns from data.csv into 10 random columns in Summary.xls

    Please Login or Register  to view this content.
    ' and so forth for 8 other columns.. however.. when I execute the macro it gets stuck on 2nd column below with comment Run-time error '9' Subsript out of range.

    Sheets("data_" & intex_date(PrevBD(Date)) & "_NY").Select
    Range("BP3:BP" & LastRow).Select
    Last edited by donyc; 03-01-2011 at 12:07 AM. Reason: amended

  2. #2
    Forum Contributor
    Join Date
    08-31-2010
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    204

    Re: Copy/Paste across worksheets doesn't work

    any suggestions where I am going wrong with this?

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Copy/Paste across worksheets doesn't work

    The error means, in this case that there is something wrong with the sheet name. You need to explain the meaning of, or show the code that initializes:
    intex_date(PrevBD(Date))
    Ben Van Johnson

+ 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