Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
this is what i get when i nudge a shape with the recorder on.....
Sub nudge() ' ' nudge Macro ' Macro recorded 1/10/2007 by Susan ' ActiveSheet.Shapes("Picture 1").Select Selection.ShapeRange.IncrementTop -0.75 Selection.ShapeRange.IncrementTop -0.75 Selection.ShapeRange.IncrementLeft -0.75 Selection.ShapeRange.IncrementLeft -0.75 Selection.ShapeRange.IncrementTop -0.75 Range("H5").Select End Sub susan XP wrote: I have a series of small images on a sheet. Each image is pasted at the top left corner of a series of cells. I want to nudge each image down and to the right just a little so that each image is the same amount of space inside each cell. I have the following code to begin with, but I can't figure out how to actually reposition the images... Dim oShape As Shape For Each oShape in ActiveSheet.Shapes oShape.[What?] Next Please correct or rewrite my code, but if possible please post example code. I thought there was a "Nudge" command that allowed a graphic to be moved just a little...? Or perhaps another command to shift it like 0.001 down and right (could be more or less, but I can adjust that later)? Thanks for the input and help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I cannot "nudge" using CTRL+arrows | Excel Discussion (Misc queries) | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel | |||
nudge | Charts and Charting in Excel | |||
Nudge entry just a hair | Excel Discussion (Misc queries) | |||
Nudge in XP | Excel Discussion (Misc queries) |