View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Native
 
Posts: n/a
Default Moving Objects in a Worksheet

Hello: I would like to move objects depending upon inputted criteria.
For example, if I have the word "apple" in cell A1, I want to move a
box around the world Apple in a list.

So far, I can record a macro moving an object and get the commands
like:

Selection.ShapeRange.IncrementLeft -81#

or

Selection.ShapeRange.IncrementLeft 35.25

, but I don't know how to say go "here" or "there". Is there a way to
have an object move to a specific location by say some sort of grid
address vs. saying go left 35.25 units?

Also, what does the # after the number mean? EG-".IncrementLeft -81#"

Thanks!