Help with VBE Need to autoselect rows

I

icestationzbra

first of all, C and D are not rows, they are columns :)...

based on activecell,

if you want to select just the cells:

Range(ActiveCell, ActiveCell.Offset(1, 0)).Select

if you want to select the entirerow:

Range(ActiveCell, ActiveCell.Offset(1, 0)).EntireRow.Selec
 
P

Paul B

greenfalcon, see if this will do what you want

ActiveCell.Resize(2, 1).EntireRow.Select

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
Top