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.

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

"Btobin0" wrote in message
...
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.

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


"Btobin0" wrote in message
...
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.

what if I am pasting to 11 cells under the active? What would I need to change?

"Paul B" wrote:

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

"Btobin0" wrote in message
...
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.

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

"Chip Pearson" wrote:

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


"Btobin0" wrote in message
...
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.