Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through a Range in Excel
Can any one suggest a way to loop through an Excel worksheet rows till
i see a null in the contents of the cell Here is sort of pseudo code. Start Worksheet("sheet").cell(row,col) < "" Worksheet("sheet").range(namedrange).value=Workshe et("sheet").range(namedrange).value & worksheet("sheet").cell(row,col).value end the loop |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through a Range in Excel
public sub test()
dim r as range set r = activeworksheet.range("A1") do while not r ="" debug.print r.address set r = r.offset(1,0) loop set r = nothing end sub Cheers, Jason Lepack On Apr 11, 12:45 pm, smartnhandsome wrote: Can any one suggest a way to loop through an Excel worksheet rows till i see a null in the contents of the cell Here is sort of pseudo code. Start Worksheet("sheet").cell(row,col) < "" Worksheet("sheet").range(namedrange).value=Workshe et("sheet").range(namedrange).value & worksheet("sheet").cell(row,col).value end the loop |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through a Range in Excel
thanks for your help Jason Lepack
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping through a Range In Excel | Excel Programming | |||
Copying Range Based On Certain Criteria? Possible looping through the Range | Excel Programming | |||
Determine if range has NO Blank Cells without looping through each cell in range | Excel Programming | |||
Looping through a range | Excel Programming | |||
Practical Excel Range Looping Project | Excel Programming |