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.