|
-
Jul 27th, 2005, 01:42 PM
#1
Thread Starter
New Member
[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.
-
Jul 27th, 2005, 03:43 PM
#2
Re: Moving activeCell to specific row, but unspecific column??
Try
VB Code:
Do Until ActiveCell.Row = 3
ActiveCell.Offset(-1,0).Select
Loop
Danny
Never Think Impossible
If you find my answer helpful then please add to my reputation
-
Jul 27th, 2005, 04:23 PM
#3
Thread Starter
New Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|