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.
Even a little help can be a big help !!
1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
4. Use [CODE] [/CODE] tags to illustrate your code: see here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks