Its ok Bob found the problem thanks again, "Learning the hard way"

"Learning the hard way" wrote:

Can anyone help? i have written a macro to copy what i want from one sheet to
another,(in the same book) but then i want it to copy on the next line when i
run it again. so as i keep the first lot of info, thus ending up with a page
of info as you go.
I have included the code so far.