Hello,

I inherit database files in Excel format from others. Because they are the
owner of the files, they sometimes modify the Header (in row 1) without
informing others.

Im intending use a macro to verify if any additional new header has been
added or old header being removed.

Example todays file header in row 1 is:
A1 = SupplierCode
B1 = SupName
C1 = SupGroup
D1 = Product
E1 = AltProduct
F1 = Description
€¦€¦etc

Then, tomorrow, he could change by slotting in an extra header called
€œProduct Sales€� right in the middle of any column.

I just need a very simple code. Just to get VBA to verify from cell A1 right
across to the last cell in row 1. Honestly, I dont even need to know which
specific cell in row1 has been changed. All I need is for VBA to €œtell me
there is a change€� when I run the code.

Many of my other database suffers the same calamity. I dont mind updating
by re-typing the header into your VBA codes. All I need is a way to spot such
changes.

Thanks a lot.

I'm a VBA rookie.

--
Edmund
(Using Excel XP)