add line during code
I am trying to have a line put in after I do this coding:
.Cells(intRow + rowCount + 2, intColumn + 10).Value = "=(I" & total_RowCOGS
& "/I" & total_IncRow & ")*.01"
..Cells(intRow + rowCount + 2, intColumn + 10).NumberFormat = "0.00%"
..Cells(intRow + rowCount + 2, intColumn + 10).Font.Bold = True
I've tried this but NO luck:
..Cells(intRow + rowCount + 2, intColumn +
10).Borders.get_Item(Excel.XlBordersIndex.xlEdgeTo p).LineStyle =
Excel.XlLineStyle.xlContinuous
Any ideas? I really would like to add this feature in. Thanks!
--
Brenda
|