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
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
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks