我想依据表AAA 中b2:b85的内容 判断是否显示c2:c85单元格内容为名字的sheet表
Private Sub CommandButton1_Click()
For i = 2 To 85
a = Sheets("AAA").Cells(i, 3)
If Sheets("AAA").Cells(i, 2) = 1 Then
Sheets(a).Visible = True
Else
Sheets(a).Visible = False
End If
Next
End Sub
运行时错误:9
谁能帮看看 哪里错了吗