Check Headings
Hello, Does anyone know how to have your macro check column headings before executing. I would like to be able to check to make sure that all the right column headings are there before the macro runs. :) Thanks, Altec101 -- Altec101 ------------------------------------------------------------------------ Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539 View this thread: http://www.excelforum.com/showthread...hreadid=549086 |
Check Headings
Maybe something like
If Range("A1").Value = "Name" And _ Range("B1").Value = "Date" And _ Range("C1").Value = "Email" ANd _ 'etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Altec101" wrote in message ... Hello, Does anyone know how to have your macro check column headings before executing. I would like to be able to check to make sure that all the right column headings are there before the macro runs. :) Thanks, Altec101 -- Altec101 ------------------------------------------------------------------------ Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539 View this thread: http://www.excelforum.com/showthread...hreadid=549086 |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com