alignment of SOME text in a textbox
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
|