The code is in the same workbook. Few of the headers are "City", "Address",
"Code1", "Code2", "Post". If you can give me code for these, then I will add
remaining headers in it.

Thank you once again. :)

"OssieMac" wrote:

Somewhere you will need a list of the 50 headers. Is this code in a separate
workbook to the ones you are testing? If so, you could have the list on a
worksheet within the workbook containing the code and I can then give you
code to loop through the list and test for all.

Can you give me a worksheet name and range where the list can be permanently
stored.

--
Regards,

OssieMac