Hello,
I would like to know if it is possible to apply 2 different alignments within 1 cell with a macro - I would like to do something like this (see below) but do not know how to do it to align $Ms below each other exactly.
Opening balance 1.0 $M
Movements w/o EAFE 4.0 $M
My code looks like this:
ce = Sheets("Fluctuation analysis for CF100").Cells(c, 3) & WorksheetFunction.Rept(" ", 100 - Len(Sheets("Fluctuation analysis for CF100").Cells(c, 3))) & WorksheetFunction.Text(WorksheetFunction.Round(Sheets("Fluctuation analysis for CF100").Cells(c, 4), 1), "#,##0.0") & " $M " & Chr(10)
I want data in bold to be right aligned to the right border of the cell while everything else should be left aligned to the left border of the cell
I would like to know if it is possible to apply 2 different alignments within 1 cell with a macro - I would like to do something like this (see below) but do not know how to do it to align $Ms below each other exactly.
Opening balance 1.0 $M
Movements w/o EAFE 4.0 $M
My code looks like this:
ce = Sheets("Fluctuation analysis for CF100").Cells(c, 3) & WorksheetFunction.Rept(" ", 100 - Len(Sheets("Fluctuation analysis for CF100").Cells(c, 3))) & WorksheetFunction.Text(WorksheetFunction.Round(Sheets("Fluctuation analysis for CF100").Cells(c, 4), 1), "#,##0.0") & " $M " & Chr(10)
I want data in bold to be right aligned to the right border of the cell while everything else should be left aligned to the left border of the cell