what type of variable is this?
 

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

what type of variable is this?
 

You would Dim it as a Range.

--
Rick (MVP - Excel)


"Robert Crandal" wrote in message
...
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