I am trying to use a macro to copy information from cells into a results table on another sheet. However currently each time I run this macro information is copied to the same cells and all of my previous results are overwritten. Is there a simple formula that I can use in my macro so that results from each macro are listed and so that new results appear in the column under the previous results??

this will select the next row below the row with data in column A
Range("A65536").End(xlUp).Offset(1, 0).Select

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"mattip" wrote in message
...
I am trying to use a macro to copy information from cells into a results
table on another sheet. However currently each time I run this macro
information is copied to the same cells and all of my previous results are
overwritten. Is there a simple formula that I can use in my macro so that
results from each macro are listed and so that new results appear in the
column under the previous results??

Yeah thats exactly what i wanted. Now I just need to put it into my table. Thanks for that it was great help.

You're welcome, and the feedback is appreciated

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"mattip" wrote in message
...
Yeah thats exactly what i wanted. Now I just need to put it into my table.
Thanks for that it was great help.