Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format a column from the last row of data on up
Merjet helped me with a macro to locate some particular data and
delete that row on down, and now I have one final formatting thing I want to do: I'd like to place a border around a column from the last row of data in the worksheet, on up to the top. The column is "AD". I'm pretty sure I can figure out the macro to find the last row, but I don't know how to fit in the code to say "format column "AD" from that row on up"!!! Thanks in advance, and thank you Merjet, for helping me with the other macro! Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format a column from the last row of data on up
Select your range:
Cells(AD1:AD lastrow ).Select Then this will format whatever you have selected: 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 Selection.Borders(xlInsideHorizontal).LineStyle = xlNone Another suggestion is to do it by hand and record the Macro while doing it then modify to just select the range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
Converting data in column to Phone Format | Excel Discussion (Misc queries) | |||
HELP ME PLEASEEE- how to format data in a column | Excel Discussion (Misc queries) | |||
Input data from file to Excel in Column Format | Excel Programming | |||
Saving a column of data in another file format | Excel Programming |