W
WhytheQ
Morning All,
Philosophical rather than practical question - I'm auditing all my
code and trying to be as explicit as possible with my variable
declarations. So really trying to avoid using Variant. I use the
following structure quite a bit:
Dim myCell
For Each myCell In .Sheets("Static").Range("xxx").Cells
If myCell <> "" Then
'code to execute here on each cell if cell not empty
End If
Next
myCell is a variant but I'd prefer to declare it as a specific data
type or object so that the code is more precise.
Any help appreciated
Jason.
Philosophical rather than practical question - I'm auditing all my
code and trying to be as explicit as possible with my variable
declarations. So really trying to avoid using Variant. I use the
following structure quite a bit:
Dim myCell
For Each myCell In .Sheets("Static").Range("xxx").Cells
If myCell <> "" Then
'code to execute here on each cell if cell not empty
End If
Next
myCell is a variant but I'd prefer to declare it as a specific data
type or object so that the code is more precise.
Any help appreciated
Jason.