#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Help!!!!

Trying to determine header character count....

..LeftHeader = Replace(custname, "&", "&&") & " - " & chitem & " Report"


..RightHeader = "Page &P Of &N"

and my comments string that is to go into the header. I have assigned left
and right header as a string value so I said

comments + Rightheader.Count + LeftHeader.Count + comments

This value came to 253 within my 255 character limit but yet it failed
saying it could not do the header.

If I put in a 5 characters total for comments it works fine.

Any ideas on what I am forgetting to count?



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



All times are GMT +1. The time now is 02:52 PM.

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

About Us

"It's about Microsoft Excel"