Hi, I'm trying to copy values from specific worksheets to a new workbook (i.e, these sheets will be the new workbook. I only want their values to be copied). The code that I have keeps giving me the "Run-time error '1004': Application-defined or object-defined error." FYI-I've already defined ws. Please help! 
Please Login or Register  to view this content.