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?

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?

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?

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?