HOW DO I MAKE CELLS FROM ONE WORKSHEET PASTE ONTO THE NEXT BLANK .

[Guest]

I have a system that posts standard e-mails into a worksheet and copies only
the ninformation needed ito another worksheet .it works fine!

Now I want to keep a record of the copied information in a third worksheet
pasting the information in a ledger type format

How do I make excel past into the next ( unoccupied) row ?

 

[Paul B]

Jim, something like this, it will select the next row down in column A that
does not have data

Range("A65536").End(xlUp).Offset(1, 0).Select

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Guest]

thank you very much for your very speedy response
I will give it a try now!