You are not very specific but maybe this?
range("a3:h3").copy sheets("destination").range("a"&m5)


Don Guillett
SalesAid Software

"kate" wrote in message
...
What I would like to do is copy and paste from a specific range using row
count.
I can copy and drop down but I only ever want it to copy and paste
required
cells.


In m5 it will show how many rows I am using from another sheet and I wish
to
copy my formulas from a3-h3 down to that specific row????