Really, Yes, amazing I know.

If you wish to find the last row in use then try this ......

vRowMax = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row

then use vRowMax plus any space you require after the last row to set the
paste location.

You will need to open the sheet first.



"Hoob-n-Tam" wrote in message
news:vLltb.152424$mZ5.1047010@attbi_s54...
Really, the only problem I am having is getting the data to paste to the
next empty row down in book2.


Thanks, Dwayne


"Nigel" wrote in message
...
If you can do it manually, turn on the macro recorder and redo it. The
macro
can then be rerun as required.

"Hoob-n-Tam" wrote in message
news:Bzftb.153915$9E1.768390@attbi_s52...
Very basic stuff here...

Trying to cut (B2:K2) from book1, sheet 1 and paste into closed Book
2,
sheet 1 next empty row down (B:K) Then save the changes/close book 2.


Any help would be greatly appreciated.
Thanks, Dwayne






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000
Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via
Encryption
=---






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---