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

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

How can I list the results of my macro without overwritng 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??

How can I list the results of my macro without overwritng 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.

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

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.