Copy paste worksheet range to existing workbook

how do i go about creating a macro to copy a range in sheet 1 in workbook A and paste that to a new tab(the last one) in the existing workbook B. i would like the tab to be renamed based on a cell value. preferably workbook B doesnt have to be open, and the save and close it

thanks for the help

so i solved my problem with your help, thanks much john. here is the code i used, i also added a sub to remove the macro buttons from the copied sheet. thanks again.

Please Login or Register  to view this content.

on second thought i thought i solved it...now it keeps giving me an error that says "the object invoked has disconected from its clients"...i have no idea how or why it happens. i can do the copy/save one time, but if i try it again it produces that error. any ideas?

well the problem was coming from

Please Login or Register  to view this content.

i wish i could figure it out so i wouldnt have to rename each on each time. i would like the tab be the date, but if i use format(now, yy-mm-dd) it produces an error since i cant have two of the same day