Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop Until out of named range
I have a Loop that I want to go until it is out of my named range
something like so Lets say I have a named range called "HiField" """""""""""""""""""""""""""""""""""""""""""""""""" """"""" Dim ntotal as string ntotal = 0 Do Range("CP1").Offset(ntotal, 0) = "HI" ntotal = ntotal + 1 Loop Until out of HiField <------This is were I need Help How would I go about telling it to loop until out of named range |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop through single column of named range | Excel Programming | |||
Redefining a Named Range In A Loop | Excel Programming | |||
If any cell in named range = 8 then shade named range | Excel Programming | |||
Loop thru named range of second sheet | Excel Programming | |||
plz help: creating named range in VBA, loop goes haywire | Excel Programming |