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.