[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
Re: Moving activeCell to specific row, but unspecific column??
Try
VB Code:
Do Until ActiveCell.Row = 3
ActiveCell.Offset(-1,0).Select
Loop
Re: Moving activeCell to specific row, but unspecific column??
Perfect, that worked
Thanks