Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Last Unused Cell
I am trying to get the last unused cell so that I can put a borde
around them. This is because my result set in the worksheet is dynami and can contain more or less values. Right now I have macro hard-codin the last cell in the range: Range("A1:H16").Select 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 How do I find he last unused cell in my range cell property? Thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find column letter of the first unused cell | Excel Worksheet Functions | |||
Copying to next unused row | Excel Worksheet Functions | |||
what to do with unused cells | Excel Worksheet Functions | |||
Code not going to next unused row | Excel Programming | |||
find next unused row | Excel Programming |