1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

a simple but complex macro - 2002 excel HELP!

Discussion in 'Business Applications' started by CBeisiegel, Feb 10, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. CBeisiegel

    CBeisiegel Thread Starter

    Joined:
    Feb 10, 2003
    Messages:
    5
    I need HELP !!!! I need a simple macro that will simply move the cursor around the spreadsheet ( right,left,up or down) without embedding the ending cell address in the macro itself !

    EXAMPLE: Macro 1 - to move the cursor (up) 1 cell, to the (right) 2 cells and ( down) 1 cell. The key is, I need the macro to do this each and every time it is executed, in this pattern, no matter where it starts ( assuming it is not blocked by margin constraints )

    PLEASE !!!!!!! I'm going crazy !

    cheyenne
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Cheyenne:

    Why would you need it to go UP once and then DOWN once?

    Why not just move two to the right?
     
  3. CBeisiegel

    CBeisiegel Thread Starter

    Joined:
    Feb 10, 2003
    Messages:
    5
    Any movement where the macro does not embed the ending cell reference is the key. If you can move to the right 2 times, without having the cell address embedded, I could use that.

    The movement I described was just an example.

    thanks
     
  4. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Sub MoveMe()

    ActiveCell.Offset(-1, 0).Activate
    ActiveCell.Offset(0, 2).Activate
    ActiveCell.Offset(1, 0).Activate

    End Sub

    Get the idea?
     
  5. CBeisiegel

    CBeisiegel Thread Starter

    Joined:
    Feb 10, 2003
    Messages:
    5
    Thank you very much. I feel rather stuipd, but whats new, my wife gives me that "are you that stupid" look all the time.
     
  6. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    LOL, Cheyenne.

    Does that code work for ya?
     
  7. CBeisiegel

    CBeisiegel Thread Starter

    Joined:
    Feb 10, 2003
    Messages:
    5
    I'm working on it now, I'll get back with you.

    Thanks
     
  8. CBeisiegel

    CBeisiegel Thread Starter

    Joined:
    Feb 10, 2003
    Messages:
    5
    Works Perfect. Can't thank you enough !

    Cheyenne
     
  9. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    No prob!

    Happy to help.
     
  10. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/118042

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice