Hi,

I have rows with formulas all input via vba with an accounting format.
These are all added by the same code but the numbers do not line up. I have
checked they are all right aligned but are not visibly right aligned. Some
cells are slightly off to the left just about a half a digit.

with MainPagepg
With .Range("M" & NextRow)
.NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)"
.HorizontalAlignment = xlRight
.FormulaR1C1 = "='" & ShName & "'!R21C11"
End With
End with

It must be a setting as it is only in some cells. since they show right
aligned I don't know what else to check.
--
Thanks for your help.
Karen53

Hi,

I found it. For some reason it set some of the cells to wrap text.
--
Thanks for your help.
Karen53


"Karen53" wrote:

Hi,

I have rows with formulas all input via vba with an accounting format.
These are all added by the same code but the numbers do not line up. I have
checked they are all right aligned but are not visibly right aligned. Some
cells are slightly off to the left just about a half a digit.

with MainPagepg
With .Range("M" & NextRow)
.NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)"
.HorizontalAlignment = xlRight
.FormulaR1C1 = "='" & ShName & "'!R21C11"
End With
End with

It must be a setting as it is only in some cells. since they show right
aligned I don't know what else to check.
--
Thanks for your help.
Karen53