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