VBA: Align part of cell to the right

[FryGirl]

I have in one cell the following. This is wrapped text, so two lines created in VBA with the Chr(10)

19 And He said to them, "Follow Me, and I will make you fishers of men."
—Matthew 4:19

The cell row height is 162. How can I get the 2nd line, —Matthew 4:19 to align bottom right of the cell. The dash is made in VBA by using Chr(151) for an em dash.

 

[CephasOz]

Would it work for you to right-align the cell, then set the column width to that of the first line? That way the first line would appear to be left-aligned and the second right-aligned.

 

[FryGirl]

No, unfortunately that won't work as I'm printing these out as a 2.5 x 3.5 card; however, I did find a solution to work with. Thank you for your time.