Logwb.worksheet(1).usedrange.copy
但是我只想拷貝不包含前3行的所以使用內容。請教該如何寫啊
uj5u.com熱心網友回復:
Dim countr As Long, countc As Long
With Logwb.Worksheets(1)
countr = .UsedRange.Rows.Count
countc = .UsedRange.Columns.Count
.UsedRange.Offset(3).Resize(countr - 3, countc).Copy
End With
uj5u.com熱心網友回復:
偷懶點的寫法,會多拷貝3行下面的空白行Logwb.Worksheets(1).UsedRange.Offset(3).Copy
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/249614.html
標籤:VBA
