-
Solved: Find next row
Sorry if this is obvious or posted somewhere else, but I can't find it. I am taking info (with VBA) from an e-mail and putting it in Excel. I have it basically all figured out, but need one last thing.
All I need is to be able to go from the active cell and move 2 rows down. So if A1 is the active cell, I want to go to A3.
Thanks In Advance
Ross
-
found the answer elsewhere
-
The code to move from one active cell elsewhere is typically
Activecell.Offset(2,0).Select
Is this what you need?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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