View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Header/Footer horizontal margins/text positioning

It is a non-breaking space character commonly used in web pages. Whether
any fonts use it as something else, I can't say.

--
regards,
Tom Ogilvy


"akhergert" wrote in message
...
Is 160 a blank character universally? One machine I tried it on still
printed a box with a gray outline- could just have been the printer

though.


"Tom Ogilvy" wrote:

try a chr(160) instead of a chr(32)

--
Regards,
Tom Ogilvy


"akhergert" wrote in message
...
Is there a way to set horizontal header/footer margins? Or, to set

the
color
of header/footer text? I need to shift a date in the right footer

leftwards
about two spaces for it to align. When I type two spaces (or any

number
of
spaces) after the date in the footer, Excel trims them.

I tried inserting two Chr(32)s (spaces) after the date in VB but they

were
still trimmed (the date is being placed in the footer using "&D" in

VB,
but I
have the same issue when I type the spaces directly after the date in

the
footer).

Also found a couple ASCII characters I didn't have on my machine, and

I
placed one after the two spaces. This succeeded in preserving the two
spaces, but when I opened the document on another machine the ASCII

character
showed up, so I need another solution.

Placing the date in the center footer and inserting a bunch of spaces

before
it to shift it rightward is not an option because the page number is

in
the
center footer.

Anyone know a way to shift text leftwards, or to set the color so I

can
put
some white characters after the date to 'shift' it over?