Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    VBA - Move Down (XL2003)

    (From the simple when you know how department...)

    What is the line of vba code that will move down from the selected cell (much like pressing the enter key)?

    When I used the macro recorder to see the results of pressing the {Enter} key, all I got was something like: <font color=blue>Range("X20").Select</font color=blue> . Got the same result when i used the down arrow. I'm trying to use code that will apply formatting to a selection and then end by going to the next cell down.
    - Ricky

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: VBA - Move Down (XL2003)

    Activecell.offset(1,0).Select

    Note that you rarely if ever need to actually select cells in code.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Thanks

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Thanks

    Your timing is perfect - I'm just off for a pint or three! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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