i change the code trying to extract city and zip only (for testing)
For j = 1 To 2
c01 = c01 & vbLf & Filter(st, Choose(j, "City :", "ZIP :"))(0)
Next

for that i did not get any error msgs also i dont get any results? why?
how can i get the data of c01 in excel?


thanks for providing a new knowledge about f8 key use