nkamp
01-29-2008, 01:24 AM
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
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