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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 ?
 
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 **
 
Back
Top