Results 1 to 3 of 3

Thread: [RESOLVED]Moving activeCell to specific row, but unspecific column??

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2005
    Posts
    14

    Resolved [RESOLVED]Moving activeCell to specific row, but unspecific column??

    Alright so what I need to do is move from the activeCell three columns to the right, which is easy enough.

    But then I need to move the activecell to the top of the page in that same column.

    For example, if the activeCell is at C11 then I need to move three to the right to F11 and then from there move up to F3.

    No matter where on the page I am I need to move up to the third row on whichever column I'm currently in.

    Does anyone know how to do this? Is there a wildcard variable I can use? Like move the activeCell to *3?

    Thanks
    Last edited by Sasaraii; Jul 27th, 2005 at 04:24 PM.

  2. #2
    Fanatic Member dannymking's Avatar
    Join Date
    Jul 2005
    Location
    Darlington, North East UK
    Posts
    677

    Re: Moving activeCell to specific row, but unspecific column??

    Try

    VB Code:
    1. Do Until ActiveCell.Row = 3
    2.     ActiveCell.Offset(-1,0).Select
    3.   Loop
    Danny

    Never Think Impossible

    If you find my answer helpful then please add to my reputation

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2005
    Posts
    14

    Re: Moving activeCell to specific row, but unspecific column??

    Perfect, that worked

    Thanks

Posting Permissions

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



Click Here to Expand Forum to Full Width