Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone help ?
I need to put border on a number of cells of which number of rows is unknown. The first routine below was originally used to find the number of rows and then fill down the columns. The 2nd part is a recording of keypresses to ut the border on the cells. HOW do I marry the two parts together in order to put borders inside and around Range ("A3:F" & LastRows) Dim LastRow As Long With Worksheets("Sheet1") LastRow = .Cells(Rows.Count, "A").End(xlUp).Row .Range("B3").AutoFill Destination:=.Range("B3:B" & LastRow) _ , Type:=xlFillDefault ---------------------------------------------------------------- Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With Regards Centurian. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
taking numbers in vertical cells putting them in horizontal cells | Excel Worksheet Functions | |||
Getting a filename into VBA and putting it into cells | Excel Discussion (Misc queries) | |||
Putting Multiple Cells into 1 | Excel Discussion (Misc queries) | |||
Putting row numbers in cells | Excel Discussion (Misc queries) | |||
how can I do this without actually putting into cells | Excel Programming |