MrExcel Publishing
Your One Stop for Excel Tips & Solutions

selecting a cell by counting rows...


Posted by Macro boy on December 31, 2001 11:08 AM

Hi. Can someone help me with code to activate the cell 49 rows down from the current active cell?

Help is appreciated.

Macro boy.


Posted by Ivan F Moala on December 31, 2001 11:15 AM

ActiveCell.Offset(49, 0).Select

Posted by JAF on December 31, 2001 11:17 AM

ActiveCell.Offset(49,0).Select

Note: With the Offset command, the first number is the number of rows to offset by (use a negative number to offest to a row above where you are) and the second number is the number of columns to offset by (use a negative number to offest to a column to the left of where you are)


Posted by Macro boy on December 31, 2001 11:42 AM

Re: ActiveCell.Offset(49, 0).Select


Thank you very much!


Posted by Macro boy on December 31, 2001 11:43 AM

Thanks for explaining it as well as giving me the code.
MMMmmmm... Knowledge...!