軟體:EXCEL
版本:2010
我有N個工作表要執行同樣操作
dim r0, r1,c0 as integer
dim ws as variant
arr = Array(18, 19, 24, 27, 28, 31, 35)
for each ws in arr
with 工作表 & ws
r0 = .Cells(Rows.Count, 9).End(xlUp).Row
r1 = .Cells(Rows.Count, 3).End(xlUp).Row
c0 = .Cells(11, Columns.Count).End(xlToLeft).Column
end with
next ws
會顯示需要物件
想請教用迴圈指定工作表的寫法?