What is the "transfer area"? A little more detail about your setup, what you
want to copy and where would be helpful. Also, posting the code you have
that works for multiple rows but not for single rows would be useful to us
too.

--
Rick (MVP - Excel)



"Amin" wrote in message
...
hi i try creating a macro to transfer data from one sheet to another but
the
pasting is becoming tricky to me. i want to be able paste more than one
row
or just one row depending on the data enterd in the transfer area. my
macro
is using the relative ref and it paste the first 4 rows i selected correct
but when i used one row it not right

i will like to paste either more or less rows but it should always go to
the
next available row thanks