PDA

View Full Version : Solved: Find next row



rsilberfarb
01-31-2006, 03:15 PM
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

rsilberfarb
01-31-2006, 03:22 PM
found the answer elsewhere

mdmackillop
01-31-2006, 03:23 PM
The code to move from one active cell elsewhere is typically
Activecell.Offset(2,0).Select
Is this what you need?