Compare and check header values based on given criteria.

[MarMo]

Hi there,

It has been a while ago that i needed to code in Excel.
not being an expert, i need some help.

I'd like to check if certain header values are correct in the header row (row A1)

For example : columns (1, 4, 7 , 10) need to be checked for values (Date, Address, Mobile, Hardware)


How can i achive this with VBA code ?
I was thinking of 2 arrays and looping through them to compare the header value and the array value.

Thanks for helping.

[jeffreybrown]

How about as a starter...

Please Login or Register  to view this content.

[Marc L]

columns (1, 4, 7 , 10) need to be checked for values
(Date, Address, Mobile, Hardware)

According to your attachment a VBA demonstration for starters :

Please Login or Register  to view this content.

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[MarMo]

Hi Jeff,

Thanks for the reply.
Just tested the code, and it works fine for me.

Regards,
Mario

[MarMo]

Hi Marc L,

Merci beaucoup.

Thans for the reply.
Just tested the code, and works fine.
Especially the speaking voice is a funny feature.

Regards,
Mario

[jeffreybrown]

Hi Mario, Glad we could offer you a couple of solutions.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[MarMo]

Hi Jeff,

I'll put the thread to [SOLVED]

I'm aware of the Add Reputation stars, and i added these for both of you when i replied.
So the appreciation star should be there.

Kind Regards,
Mario