Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    moving within a selected range (2003)

    I copy a range(A10:v53) from one workbook and paste into another. Once i have pasted, the active selection is now range(A1:W44), with A1 the "?activecell?". I need to relatively offset (2, 3) within my range(A1:W44) and make that cell current or active. How do i do this?

    thanks,
    Josh

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

    Re: moving within a selected range (2003)

    I don't understand why copying and pasting a range in columns A:V results in a selection in columns A:W.

    Can't you simply use

    Range("D3").Activate

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: moving within a selected range (2003)

    Oops. My mistake on the range from A:V to A:W.

    Range("D3").Activate
    will work the first time i run the macro. But the next time i run the macro I will not want to use D3, I will want to use the offset(3,2) from the newly pasted range.

    Josh

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

    Re: moving within a selected range (2003)

    Try

    Selection.Range("D3").Activate

    This will make it relative to the current selection.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: moving within a selected range (2003)

    Does the following do what you want?

    <code>
    ActiveCell.Offset(3,2).Activate
    </code>
    Legare Coleman

  6. #6
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: moving within a selected range (2003)

    Thanks to both of you!!

    thanks,
    jackal

Posting Permissions

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