Looping through rows by colomn name?

[nkamp]

Hello,

is it possible to loop through the rows by column name like:

(Ordnumb is the defined colomn name)

While (Trim(Worksheets("openstaande orders").Range(Ordnumb & iRijTel)) <> ""
iRijTel = iRijTel + 1
Wend

instead of: ("A")

While (Trim(Worksheets("openstaande orders").Range("A" & iRijTel)) <> ""
iRijTel = iRijTel + 1
Wend


Thanks in advance,

Nico

[Bob Phillips]

While Trim(Worksheets("openstaande orders").Cells(iRijTel, Range("Ordnumb").Column)) <> ""
iRijTel = iRijTel + 1
Wend