does this help
x=cells(rows.count,"b").end(xlup).row+2
range("b4:j7").copy range("b" & x)

--
Don Guillett
SalesAid Software

"Steven" wrote in message
...
I want to record a macro that will copy cells B4:J7 and paste them
starting at B10. Skipping two rows from the bottom of what I am copying.
However, everytime I run the macro I want it to skip 2 rows two past. so the
first time i run it it would paste in B10. The second time I run it would
paste at B16 and so on and so forth. Any thoughts?