S
smartnhandsome
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 suedo code.
Start
Worksheet("sheet").cell(row,col) <> ""
Worksheet("sheet").range(namedrange).value=Worksheet("sheet").cell(row,col).value
end the loop
i see a null in the contents of the cell Here is sort of suedo code.
Start
Worksheet("sheet").cell(row,col) <> ""
Worksheet("sheet").range(namedrange).value=Worksheet("sheet").cell(row,col).value
end the loop