Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Draw border above specific text string
Hello All,
I am using Office XP and have the following problem: I have many thousand Rows of Data in a Sheet. I wish to make a Selection and run the macro which should draw a border in red colour above a text string which is written in D1 for eg Membership The border in red colour should be drawn on the row above the word Membership in the Sheet. Pls note that the macro should run for any text string entered in D1 as a part only.. I mean it should be treating Member, Membership, Membership No. etc etc... all as one. Because my Sheet has a value Membership No. xxxx (where xxxx differs for each record) Any help or suggestions Can this be achieved? Many thanks in advance Rashid Khan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Draw border tool - Excel2007 | Excel Discussion (Misc queries) | |||
Finding specific text in a string | Excel Worksheet Functions | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Erase & Draw Border functions no longer work | Excel Discussion (Misc queries) |