Thread: Saving activesheet as csv in new workbook: I paste then save it butit saves it in sheet3 not Sheet1?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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?

Reply With QuoteReply With Quote