sub 呵呵() dim dyg as range,i% for each dyg in range("d:d")'这里变量名写错了 if dyg.value<>""then for i=1 to 1000 cells(i,"f")=val(right(dyg,5))/1000 next end if next end sub
杭州工行:icbkcnbjhzu codes: bic code icbkcnbjhzu institution name industrial and commercial bank of china branch name(hangzhou city branch) address: city heading hangzhou address 7-2 huansha road zip code...