我想将多个工作表设置为宏的范围 [英] I want to set multiple sheets as the range for macro

问题描述

我想在宏的开始处设置多个工作表(sheet1，sheet2)，而现在不起作用.

I want to set multiple sheets(sheet1 , sheet2) at the start of the macro and at the moment it is not working.

Private Sub Workbook_Open()
'Dim ws As Worksheet: Set ws = Sheets("sheet1","sheet2")
    If Range("W6").Value = 0 Then
        Call HideFG
    Else
        Call HideF
    End If
End Sub

推荐答案

您似乎正在尝试将多个工作表收集到一个参考中:

you appear to be trying to gather multiple sheets into one reference:

Set ws = Sheets("sheet1","sheet2")

您可以几乎执行以下操作:

Sheets(Array("sheet1","sheet2"))

但是，您一次只能处理一张纸..因此您需要像这样使用它:

However, you have to work on one sheet at a time.. so you need to use it like so:

For Each ws In Sheets(Array("sheet1", "sheet2"))

    If ws.Range("W6").Value = 0 Then
        Call HideFG
    Else
        Call HideF
    End If

Next

这篇关于我想将多个工作表设置为宏的范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！