ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Check Headings (https://www.excelbanter.com/excel-programming/363464-check-headings.html)

Altec101[_16_]

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


Bob Phillips

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