Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
How can I declare a variable and then assign to a row so that it can be used
in a for loop? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
Hi Nir20,
Dim rw As Long For Each rw In Selection.Rows 'Processing code Next rw --- Regards, Norman "nir020" wrote in message ... How can I declare a variable and then assign to a row so that it can be used in a for loop? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
I think that should be
Dim rw As Range -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Norman Jones" wrote in message ... Hi Nir20, Dim rw As Long For Each rw In Selection.Rows 'Processing code Next rw --- Regards, Norman "nir020" wrote in message ... How can I declare a variable and then assign to a row so that it can be used in a for loop? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding
Hi Bob,
It certainly should! Thank you, --- Regards, Norman "Bob Phillips" wrote in message ... I think that should be Dim rw As Range -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Norman Jones" wrote in message ... Hi Nir20, Dim rw As Long For Each rw In Selection.Rows 'Processing code Next rw --- Regards, Norman "nir020" wrote in message ... How can I declare a variable and then assign to a row so that it can be used in a for loop? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coding | Excel Discussion (Misc queries) | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
Implant macro coding into ASP coding | Excel Programming | |||
coding help again | Excel Programming | |||
Coding | Excel Programming |