SMC
01-08-2007, 05:50 PM
A strange problem with a cell formatting.
I have some dynamic (vba) formating on my Sheet, means that an old format can be left although the cell is empty.
Because of that i've made a code which should take along the format of certain value.
But it doesn't work well:
.
.
.
If (Size.Text = dx.SizeX(k)) Then
ActiveSheet.Cells(6 + stepX + i, k + 2).Select
ActiveCell.Font.Bold = False
ActiveCell.Font.Italic = False
ActiveCell.Font.Name = "Arial"
ActiveCell.Font.Size = 10
ActiveCell.Value = Amount.Text when this code encounters a cell which was previously formated as bold i get the value bolded, what i don't want.:bug:
Thanks
I have some dynamic (vba) formating on my Sheet, means that an old format can be left although the cell is empty.
Because of that i've made a code which should take along the format of certain value.
But it doesn't work well:
.
.
.
If (Size.Text = dx.SizeX(k)) Then
ActiveSheet.Cells(6 + stepX + i, k + 2).Select
ActiveCell.Font.Bold = False
ActiveCell.Font.Italic = False
ActiveCell.Font.Name = "Arial"
ActiveCell.Font.Size = 10
ActiveCell.Value = Amount.Text when this code encounters a cell which was previously formated as bold i get the value bolded, what i don't want.:bug:
Thanks