D
Dom
I have several sheets with a text box giving various instructions.
All of the text is left aligned. But the last line is "Copyright,
2012", and this last line I want right aligned. Of course, I can do
it through the Excel interface, but when I turn the macro recording
on, I get a blank macro. Does anyone know the VBA code?
Remember, I need to align only part of the text, not the entire text
box. I've tried ...
ActiveSheet.Shapes(1).select
Selection.characters(?,?).alignment
.... but it doesn't work.
TIA,
Dom
All of the text is left aligned. But the last line is "Copyright,
2012", and this last line I want right aligned. Of course, I can do
it through the Excel interface, but when I turn the macro recording
on, I get a blank macro. Does anyone know the VBA code?
Remember, I need to align only part of the text, not the entire text
box. I've tried ...
ActiveSheet.Shapes(1).select
Selection.characters(?,?).alignment
.... but it doesn't work.
TIA,
Dom