Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can information from a cell be placed over the top of an object? | Excel Discussion (Misc queries) | |||
Cell and Object change | Excel Discussion (Misc queries) | |||
Cutting cell with object | Excel Programming | |||
Move shape, object, pic to center of new cell based on cell value | Excel Programming | |||
Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell? | Excel Programming |