excel - 如何在 VBA/excel 中正确转义范围

Question

我有下面的这段代码。我正在努力使用公式并正确尝试连接范围并正确转义(双双引号？)范围。

Worksheets(ws_name).Range("B" & (row + 1)).Formula = "=COUNTIF(""B2:B"" & row, "">0"")"

我已经搜索和搜索，但找不到我的问题!

Dim ws_name
Dim row As Long
For Each ws_name In Worksheet_array
    If (ws_name <> "") Then
        Debug.Print ws_name
        row = Worksheets(ws_name).Range("B" & rows.count).End(xlUp).row
        Worksheets(ws_name).Range("B" & (row + 1)).Formula = "=COUNTIF(""B2:B"" & row, "">0"")"
    End If
Next ws_name

Answer 1

尝试，

Worksheets(ws_name).Range("B" & (row + 1)).Formula = "=COUNTIF(B2:B" & row & ", "">0"")"