Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bordering Groups of Data
Is it possible to apply a border around groups of data.
For example, give the the sample sheet below, a border would surround the groups of fruit. Borders would highlight the Apple, Orange, and Pear sections. A B C ==================== Apple 12 13 Apple 13 2 Apple 4 5 Orange 40 12 Pear 45 13 Pear 4 11 Is thier a simple way to have this automatically applied or must it be done programmatically. The data within the sheet is refreshed daily. In lieue of setting the borders manually, I'd like to have a more automated approach. If it must be done programmatically, what would the routine look like in general. Would I need to scan the column containing the grouping field to help define the range or is their another approach to setting the borders? Lastly, can the code be tied to an event that run when the workbook is opened and the borders haven't been applied? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bordering in Excell | Excel Discussion (Misc queries) | |||
line bordering hidden cells | Excel Discussion (Misc queries) | |||
A query in continuation to the nested bordering - To TOM, JIM and others.... | Excel Programming | |||
Bordering | Excel Programming | |||
Cell bordering | Excel Programming |