what type of variable is this?

[Robert Crandal]

I am currently writing code in my Worksheet_Change()
as follows:

Private Sub Worksheet_Change (ByVal Target as Range)
For Each t in Target
' Do stuff
Next
End Sub


If I decide to use "Option Explicit" in this module, I believe
that the compiler will ask me to declare the variable "t"
above. What type should I declare "t"?? Should it
be "Dim t as Range"??? or "Dim t as Variant"??? or
something else?


thank u

 

[Rick Rothstein]

You would Dim it as a Range.