Paste under selected cell

B

Btobin0

I have macro that when selected, grabs the information and run a search. I am
trying to find a way to return the information under the selected cell.
 
P

Paul B

Btobin0, this will get you the cell under the active one

ActiveCell.Offset(1, 0).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 2002 & 2003
 
C

Chip Pearson

ActiveCell(2,1) will refer to the cell directly below the active
cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Btobin0

ok, let me ask this: if I have b2 as my selected cell, how can I paste to b3
thru b13
 
Top