This one has me confused.
Not expecting it to work, I threw the following line intoa module:


Code:
--------------------
.Range("F16").Alignment = msoTextEffectAlignmentCentered
--------------------


Surprisingly it worked, centering the text in the cell or block of
cells.

I did a number of modifications to the code today, but nothing that I
would think have any impact on that whatsoever, but now I am getting
the error statement I originally expected to the effect of "This object
does not support that property or method."

Other than voodoo, can anyone suggest what might be going on?


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=558995