Maybe this. All ONE line
sheets("source").range("a4:h4").copy sheets("destination").range("a5:h" &
m5)

--
Don Guillett
SalesAid Software

"kate" wrote in message
...
I apologise in M5 it tells me at this precise month how many rows from
sheet
1 should have formulas copy and pasted e.g

Cell m5 shows 697

So i would like my range to be copy (a4:h4)
to a5:(and this is where i get stuck) down to h697 by looking up cell m5??
Is this any clearer???
Thanks


"Don Guillett" wrote:


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????