Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello.
I need some guidance here. I want to dimension a variable and use it in a "For Each" structure to iterate through the "used range" in a sheet. I'm using "Option Explicit". In this structure the variable has to be an object or variant. Since there is no "Column" object already defined, what should I use that would be most efficient and need the least overhead? i.e. Should I just "Dim as Variant" or something else? Your example code would be most appreciated. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SOLVER does not iterate / work | Excel Discussion (Misc queries) | |||
How can I iterate numbering when printing | Excel Discussion (Misc queries) | |||
Iterate Circular Reference | Excel Discussion (Misc queries) | |||
Iterate though all open spreadsheets | Excel Worksheet Functions | |||
How do I fill down formulas so they iterate in intervals other th. | Excel Worksheet Functions |