Thread: Check Headings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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