Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What Variable-type should I use | Excel Programming | |||
Variable type | Excel Programming | |||
Type of variable | Excel Programming | |||
Variable type Confusion | Excel Programming | |||
Trouble with variable type | Excel Programming |