View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brenda Brenda is offline
external usenet poster
 
Posts: 137
Default 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