| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
find last row, add "Total" in col B & border
How is this?
With [B65536].End(xlUp).Offset(1, 0) .Value = "Total" .Offset(0, 1).Resize(1, 13).Borders(xlEdgeBottom).Color = RGB(255, 0, 0) .Offset(0, 1).Resize(1, 13).Borders.LineStyle = xlDouble End With Regards Robert McCurdy "AGnes" wrote in message ... I want to find the last row in a worksheet, then add the text "Total" under column B, and add a border from column C thru O: ..Borders(xlEdgeBottom) ..LineStyle = xlDouble How can I select the range? -Agnes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
| Find the word "total" in a cell, delete row or column | Excel Programming | |||
| Find the word "total" in a cell, delete row or column | Excel Programming | |||
| Search "Total" in all worksheets and delete rows containing "Total" | Excel Programming | |||
![Robert McCurdy[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
