Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the headings from A1 A2 etc to show my headings? JaneyMae1 Excel Discussion (Misc queries) 3 October 9th 09 04:17 PM
Worksheet has numeric column headings. Change to alpha headings? Be Frank Excel Discussion (Misc queries) 1 June 18th 08 04:22 PM
Column headings to numbers and row headings to alphabets? Juliana Excel Discussion (Misc queries) 2 May 9th 08 05:58 PM
Increase size of a Forms Check Box (click on to enter check mark) 718Satoshi Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"