I'm having a bit of trouble trying to format a range of cells in Excel. I can change font, size, bold and place borders around a range of cells but I am looking for a method to color and format the number of decimal places in a cell. Any ideas?
I have been using methods as below, but being quite inexperienced at this stuff, I am having great trouble in finding the correct methods. Any help in this matter would be greatly appreciated!
Thanks in advance.
.Range("E3").Select()
.ActiveCell.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight
.Range("a1:w10").BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic)
.Range("R3:r9").Font.FontStyle = "Bold"
I have been using methods as below, but being quite inexperienced at this stuff, I am having great trouble in finding the correct methods. Any help in this matter would be greatly appreciated!
Thanks in advance.
.Range("E3").Select()
.ActiveCell.HorizontalAlignment = Excel.XlHAlign.xlHAlignRight
.Range("a1:w10").BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic)
.Range("R3:r9").Font.FontStyle = "Bold"
