ExcelBanter - Saving activesheet as csv in new workbook: I paste then save it butit saves it in sheet3 not Sheet1?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Saving activesheet as csv in new workbook: I paste then save it butit saves it in sheet3 not Sheet1? (https://www.excelbanter.com/excel-programming/418039-saving-activesheet-csv-new-workbook-i-paste-then-save-butit-saves-sheet3-not-sheet1.html)

Simon[_2_]

Saving activesheet as csv in new workbook: I paste then save it butit saves it in sheet3 not Sheet1?

Why would this be?

Sheet 1 is the sheet selected (by default) to be used for pasting in a
new workbook.

Seems odd?

joel

Saving activesheet as csv in new workbook: I paste then save it b

It is not Sheet1 but the ActiveSheet that gets saved.

"Simon" wrote:

Why would this be?

Sheet 1 is the sheet selected (by default) to be used for pasting in a
new workbook.

Seems odd?

All times are GMT +1. The time now is 05:43 PM.