Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    errror in selection copy (2000 sr-1)

    foglio="luststp"
    dim riga as long

    have error here:
    Worksheets(FOGLIO).Cells(RIGA, 1), Worksheets(FOGLIO).Cells(RIGA, 25)).Copy
    iw ant to copy from A to V

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

    Re: errror in selection copy (2000 sr-1)

    Does this work better?

    Worksheets(FOGLIO).Cells(RIGA, 1).Copy Destination:=Worksheets(FOGLIO).Cells(RIGA, 25)

    Note: column 25 is column Y, not column V. V is 22.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: errror in selection copy (2000 sr-1)

    sorry Hans,

    but i want to set the range of copy from A to V

    similar:

    .Range(.Cells(RIGA, 1), .Cells(RIGA, 22)).Copy

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

    Re: errror in selection copy (2000 sr-1)

    This?
    <code>
    With Worksheets(FOGLIO)
    .Range(.Cells(RIGA, 1), .Cells(RIGA, 25)).Copy
    End With</code>

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: errror in selection copy (2000 sr-1)

    YES, work!
    But now have difficult to past the entire selection copyed into

    Sheets("LUST091_STORIA").Cells(RIGA1, 1)

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

    Re: errror in selection copy (2000 sr-1)

    You can specify the destination:
    <code>
    With Worksheets(FOGLIO)
    .Range(.Cells(RIGA, 1), .Cells(RIGA, 25)).Copy _
    Destination:=Workheets("LUST091_STORIA").Cells(RIG A1, 1)
    End With</code>

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: errror in selection copy (2000 sr-1)

    TKS!

Posting Permissions

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