LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default Nudge graphics down and right

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I cannot "nudge" using CTRL+arrows david.from.nz Excel Discussion (Misc queries) 2 July 6th 08 12:07 PM
Excel 2003: How to nudge a chart element or shape on a chart? Ted M H Charts and Charting in Excel 5 June 30th 08 07:08 PM
nudge szelinko Charts and Charting in Excel 2 October 19th 07 05:47 PM
Nudge entry just a hair [email protected] Excel Discussion (Misc queries) 1 August 29th 06 01:02 AM
Nudge in XP RedChequer Excel Discussion (Misc queries) 2 September 19th 05 10:33 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"