View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ROn... ROn... is offline
external usenet poster
 
Posts: 5
Default SheetsInNewWorkbook

Hello,

Does someone know why this doesn't work in VBA (Excel 97):

lTemp = Application.SheetsInNewWorkbook
Application.SheetsInNewWorkbook = 1
Set wbTarget = Workbooks.Add
Application.SheetsInNewWorkbook = lTemp

Gr. ROn...