View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WhytheQ WhytheQ is offline
external usenet poster
 
Posts: 246
Default Why is Cell not an object

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.