Hi Harish,

2) no - postcode is always not the last field. In some records, they are
in
2nd column and in some they are in 3rd column and so on

Rephrasing my question : is the post code always the final item? In other
words, if the post code appears in (say) column 2, subsequent columns will
be blank?

3) they don't have fixed format. To give you some examples -
AB24 5QH, DY8 3HX, IG19JX etc

If the post code is not necessarily two expressions, as in the last example,
and the position of the code is not fixed, how is the post code to be
identified? For VBA code to process the post code, it is necessary to
enunciate a means of unique identification.

---
Regards,
Norman


"Harish Mohanbabu" wrote in message
...
Hi,

Thanks for your replies :)

Norman - to answer your queries -
1) yes - all records contain postcode
2) no - postcode is always not the last field. In some records, they are
in
2nd column and in some they are in 3rd column and so on
3) they don't have fixed format. To give you some examples -
AB24 5QH, DY8 3HX, IG19JX etc

Toppers,
A daft question. I am not clear on the following -
- how to implement this solution
- also I don't understand certain what do you mean when you say 'Lastrow'.
Could you elaborate on this please.

Thanks in advance,

Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/