Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
Continue line of VBA code on the next line | Excel Programming | |||
Help with 1 code line | Excel Programming | |||
Help with 1 code line | Excel Programming | |||
Same code, different line | Excel Programming |