Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2008
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying range (Excel 2003)

    I am trying to copy all the cells from row F10 to the end of the data. I have a relative named range called "Data_rows" which is defined as ('Data'!$F$10trInsertData'). "ptrInsertData" is a named range which is a cell at the end of the worksheet.
    When I try to select this range (using worksheet.range("Data_rows").select) , I get this error:
    Run-time error '1004' : Method 'range' of object '_worksheet' failed.
    Can anyone help?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying range (Excel 2003)

    Could you post (a stripped down copy of) your workbook?

  3. #3
    New Lounger
    Join Date
    Oct 2008
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying range (Excel 2003)

    See attached. thanks.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying range (Excel 2003)

    You have defined a range named ptrInsertRow but not a range named ptrInsertData, hence the definition of Employee_data_rows isn't valid.

  5. #5
    New Lounger
    Join Date
    Oct 2008
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying range (Excel 2003)

    Thank you.

Posting Permissions

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