software

I have a single page in Excel that is formattted to be a series of objects
(boxes) at the top of the page that will take you to selected text lower in
the page. I need a macro that will take me to the selected text and will
remain with that text even if additional rows are inserted above it.

I tried creating a object next to my text and linking the macro to it. The
object will move with the text but I cannot get the macro to quot;go toquot; the
object, it only moves to that cell. Once more data is inserted above it, the
macro take me to the original cell rather than moving with my text.

Thank-you for any help you can offer.

Why not select the destination text, create a range name referring to the
selection, and then let your macro go to the range name instead. If rows get
added above, the range name remains the first line of text, therefore not
affecting you.

quot;areaumequot; wrote:

gt; I have a single page in Excel that is formattted to be a series of objects
gt; (boxes) at the top of the page that will take you to selected text lower in
gt; the page. I need a macro that will take me to the selected text and will
gt; remain with that text even if additional rows are inserted above it.
gt;
gt; I tried creating a object next to my text and linking the macro to it. The
gt; object will move with the text but I cannot get the macro to quot;go toquot; the
gt; object, it only moves to that cell. Once more data is inserted above it, the
gt; macro take me to the original cell rather than moving with my text.
gt;
gt; Thank-you for any help you can offer.