Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the headings from A1 A2 etc to show my headings? | Excel Discussion (Misc queries) | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |