Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro linked to text or an object
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 "go to" 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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro linked to text or an object
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. "areaume" wrote: 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 "go to" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
Need macro to delete all text cells in an Excel range | Excel Worksheet Functions | |||
Insert text in a cell with a macro | Excel Discussion (Misc queries) | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Copying Text to Clip Board Using a Macro | Excel Discussion (Misc queries) |