anchor an object to a cell

[Bobbie]

I have an object that floats on this spreadsheet. I want
to anchor it to a specific cell so that when I resort the
spreadsheet the object will go with that specific row. In
this casae the object is an embedded equation object.
Thank you.

 

[Bernie Deitrick]

Bobbie,

You can't anchor a drawing object to a cell in a way that will carry
through a sort. What I have done is name the object in manner that
will allow you to match the object up with the new cell where it
should be and move it, using a macro. For example, if the cell has
the value "Fred" in it, name the object "objFred", then find the cell
with the value "Fred" after the sort, and move the object "objFred" as
appropriate.

HTH,
Bernie
MS Excel MVP