软件: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
会显示需要物件
想请教用循环指定工作表的写法?