PDA

View Full Version : add aorrowshape



u25103
03-02-2011, 08:26 AM
Hi

I'm trying to add a uparrow but I want to place it on a active/selected cell

ex

Activecell.offset(5,1).select

ActiveSheet.shapes.AddShape(msoShapeUpArrow, selection, selection, 16.5, 72).Select



thanks

p45cal
03-02-2011, 09:01 AM
ActiveSheet.Shapes.AddShape(msoShapeUpArrow, Selection.Left, Selection.Top, 16.5, 72).Select