+ Reply to Thread
Results 1 to 5 of 5

How can I move the cell pointer down one row in a macro command?

  1. #1
    Ken
    Guest

    How can I move the cell pointer down one row in a macro command?

    I am trying to find the macro command that automatically move the cell
    pointer down one row. Exampl: for the end-up command you would write:
    Selection.End(xlUp).Select .... What would it be to just move down One
    cell????

  2. #2
    Forum Contributor
    Join Date
    10-03-2004
    Posts
    102

    ActiveCell.Offset(1, 0).Range("A1").Select

    ActiveCell.Offset(1, 0).Range("A1").Select

  3. #3
    Dave Peterson
    Guest

    Re: How can I move the cell pointer down one row in a macro command?

    Or just
    activecell.offset(1,0).select



    Chuckles123 wrote:
    >
    > ActiveCell.Offset(1, 0).Range("A1").Select
    >
    > --
    > Chuckles123
    > ------------------------------------------------------------------------
    > Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
    > View this thread: http://www.excelforum.com/showthread...hreadid=570975


    --

    Dave Peterson

  4. #4
    Ken
    Guest

    Re: How can I move the cell pointer down one row in a macro comman



    Thank You for the info.. It works pretty good

  5. #5
    Ken
    Guest

    Re: How can I move the cell pointer down one row in a macro comman



    Thanks for the Info.......

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1