| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to change cell borders
Many thanks Tom
Roddie "Tom Ogilvy" wrote: Here is another possibility Sub yay() For Each h In ActiveSheet.UsedRange.Cells For i = 5 To 10 If h.Borders(i).Weight < xlThin Then _ h.Borders(i).Weight = xlThin Next Next End Sub -- Regards, Tom Ogilvy "Roddie Grant" wrote in message ... Excellent Ben. Many thanks! Roddie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you change the preset borders on the Formating Tool bar? | Excel Discussion (Misc queries) | |||
| How can I change the color/type of the borders I put on cells? | Excel Discussion (Misc queries) | |||
| How do I change the default color for borders in Excel 2003? | Excel Discussion (Misc queries) | |||
| macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
| Button to change borders | Excel Discussion (Misc queries) | |||
![Roddie Grant[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
