| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is is possible to set a border NOT on the edge of a cell?
I am looking to create a macro that either pastes a mini-image or
formats a diamond shaped border in each cell of a selected range. I know how to do the macro, but cant figure out either how to paste an small image in each cell or add a non-traditional border. Using Excel 2002 for windows. I know a fair amount of VBA. -Abe |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is is possible to set a border NOT on the edge of a cell?
Abraham,
A border, by definition, is on the edge. How about placing a shape in the correct place. e.g ActiveSheet.Shapes.AddShape(msoShapeDiamond, ..... NickHK wrote in message oups.com... I am looking to create a macro that either pastes a mini-image or formats a diamond shaped border in each cell of a selected range. I know how to do the macro, but cant figure out either how to paste an small image in each cell or add a non-traditional border. Using Excel 2002 for windows. I know a fair amount of VBA. -Abe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I print edge to edge with absolutely NO margins | Excel Worksheet Functions | |||
| Printing edge to edge and automatically generating a new page query | Excel Discussion (Misc queries) | |||
| border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
| Horizontal arrow on cell edge and double-click, no matches found. | Excel Worksheet Functions | |||
| Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
Linear Mode
