Thread
:
SheetsInNewWorkbook
View Single Post
#
1
Posted to microsoft.public.excel.programming
ROn...
external usenet poster
Posts: 5
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...
Reply With Quote
ROn...
View Public Profile
Find all posts by ROn...