To only save sheet1, this code is not working. Help please! Worksheets("Sheet1").save Thanks!
D Damil4real Mar 16, 2009 #1 To only save sheet1, this code is not working. Help please! Worksheets("Sheet1").save Thanks!
R rspowell Mar 16, 2009 #2 To only save sheet1, this code is not working. Help please! Worksheets("Sheet1").save Thanks! Click to expand... Mr. T -- Worksheet objects do not have a Save method - but Workbooks do If you want to copy out Sheet1 to another workbook then save it - use ... Worksheets("Sheet1").Copy .... then ... ActiveWorkbook.Save Hope it helps you, - Rodney POWELL Microsoft MVP - Excel www.BeyondTechnology.com
To only save sheet1, this code is not working. Help please! Worksheets("Sheet1").save Thanks! Click to expand... Mr. T -- Worksheet objects do not have a Save method - but Workbooks do If you want to copy out Sheet1 to another workbook then save it - use ... Worksheets("Sheet1").Copy .... then ... ActiveWorkbook.Save Hope it helps you, - Rodney POWELL Microsoft MVP - Excel www.BeyondTechnology.com
