Hey Steve,
You know me... The devil is in the details... LOL!
What exactly do you expet and what exactly are you getting?
What's being "cut off"?
What's the full line of code?
Lisa
> Subject: [ExcelVBA] Code to Enter Header Information
>
> Hi,
>
> I have the following in a code to add information on three lines:
>
> .CenterHeader = "&28SFC 052" & Chr(10) & "&20&A" & Chr(10) &
> "&16&D&"" - ""&T"
>
>
> Its supposed to have "SFC 052" on the top line, the Tab Name
> on the second line and the Date and Time on the third line.
>
> For some reason, it is cutting off the Date & Time third row
> every time. Any ideas as to why this might be happening,
> please let me know.
>
>
> Thanks,
>
> Steve
__._,_.___
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar