Excel-VBA:需要变量声明吗? [英] Excel-VBA: Variable declaration necessary?

问题描述

如果编写下面的代码，那会错吗

Would it be wrong if write the following code

Sub Something()
 Dim i As integer
 Dim xRange As Range
 Dim yRange As Range

 Set xRange= Range("x_table")
 Set yRange= Range("y_table")

 For i = 1 To xRange.Columns.Count
    xRange.Columns(i) = Application.Sum(y_table.Columns(i))
 Next i
End Sub

是否没有特别声明每个变量?像吼叫声；

without specifically declaring each of the variables? Like bellow;

Sub Something()
 Set xRange= Range("x_table")
 Set yRange= Range("y_table")

 For i = 1 To xRange.Columns.Count
    xRange.Columns(i) = Application.Sum(y_table.Columns(i))
 Next i
End Sub

推荐答案

如果未打开Option Explicit，则可以这样做，但我不建议这样做，因为那样的话，重新依赖框架猜测要处理的变量的类型，这可能会导致意外的结果.

If Option Explicit isn't turned on you can do it that way, but I wouldn't recommend it because then you're relying on the framework to guess at the type of variable it is dealing with, which could cause unexpected results.

这篇关于Excel-VBA:需要变量声明吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！