How can I list the results of my macro without overwritng previous results?

[mattip]

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

 

[Paul B]

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

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

 

[mattip]

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

 

[Paul B]

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

Yeah thats exactly what i wanted. Now I just need to put it into my table.

Thanks for that it was great help.