Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for selecting all cells
I'm trying to create a macro that will select all my cells from the beginning
(top left) to the last one (bottom right corner) and then put a border around them. Any help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for selecting all cells
one way:
Dim vSides As Variant Dim i As Long vSides = Array(xlEdgeTop, xlEdgeBottom, xlEdgeLeft, xlEdgeRight) With ActiveSheet.UsedRange.Borders For i = 0 To UBound(vSides) With .Item(vSides(i)) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With Next i End With In article , "Andre" wrote: I'm trying to create a macro that will select all my cells from the beginning (top left) to the last one (bottom right corner) and then put a border around them. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How can I get excel to ignore formula in dependant cells... | Excel Worksheet Functions | |||
self-updating formula | Excel Discussion (Misc queries) | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |