第一個問題:用UsedRange取得當然Sheet實際使用了的區域,如樓上所示
第二個問題:
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.ADD
Set xlSheet = xlBook.Worksheets("Sheet2")'--------------看這里,設為"Sheet2"就行了