View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default How to write macro to move object via if function

Can't be done. User defined functions can return a result, they can
manipulate objects.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ged" wrote in message
...
All
I am trying to write a macro that will move an auto shape depending upon

the
results of an IF condition. i.e. if A1<A2 move object from here to there.

Thanks in advance