Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, Ive got a question about how to re-position a shape (type 13).
Ive got a spreadsheet that has a bunch of little pictures nested each in its own cell. what im trying to do is center the picture in the center of the cell. Im getting an error on "selection.shaperange.incrementtop 10" what am i doing wrong? any help would be great, thanks in advance For Each C In Activesheet.Range("E11:BF100") C.Select On Error Resume Next 'if no shape in that cell Selection.ShapeRange.IncrementTop 10 Selection.ShapeRange.IncrementLeft -1 On Error GoTo 0 Next C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making the text in a cell with a money format centered | Excel Discussion (Misc queries) | |||
Changing position of shapes in chart | Excel Discussion (Misc queries) | |||
checkbox centered in cell | Excel Programming | |||
Adding Shapes: Position changes when running code a second time - Why? | Excel Programming | |||
Cell alignment centered | Excel Programming |