View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
MBaas MBaas is offline
external usenet poster
 
Posts: 3
Default Setting LeftHeader / CenterHeader

Tom Ogilvy schrieb:
I believe the limit is 255.


Thanks Tom,

I've done some more experiments with my code: if I rearrange it, so
that LeftHeader is set first and then CenterHeader, I can put the full
text to LeftHeader (209 chars) and get the error-msg when trying to put
79 chars to CenterHeader.

And then I've put 252 chars into .LeftHeader - and got the error when I
tried to assign .CenterHeader="x". So it seems there is a limit
'around' 255 for the cumulated length of LeftHeader + CenterHeader?

I don't think this is documented anywhere (in easily accessible
'official' doco, that is) and of course such a restriction seems to be
rather poor for a version 2003 :((

Any ideas how I might get around?

Thanks

Michael