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!
|