Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro - delete row if cell contains string
Hi all,
Can some one help me please! Here is a slightly more complex macro that I really need. I have a list of domain names in excel for example: 1 www.throneofnails.com 2 www.throneofnails.com/info/index.html 3 www.fairkess.com/en/business/industrie.html 4 www.endlessdecor.com/Links.html 5 www.retractableawnings.com/resources.htm 6 www.ffbd-tm.com 7 www.ffbd-tm.com/test I need a macro that will delete all the top level domain names eg www.throneofnails.com and delete all files in that domain eg www.throneofnails.com/info/index.html. I need to be left with a list of only domain names like domain name 3,4 and 5. I think it will probably have something to do with finding the cells that dont contain a "/" then loading them into an array then deleting all cells that contain the contents of that array. Unfortunately I dont have the programing language to do this. Your help would be much appreciated. Many thanks Alex Kemsley |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro syntax to check string length in a cell | Excel Discussion (Misc queries) | |||
How can delete the duplicate word from a string in cell in EXCEL | Excel Discussion (Misc queries) | |||
How do I delete part of a text string in every cell it appears in | Excel Discussion (Misc queries) | |||
A Macro to replace a string in a cell with a string from another cell??? | Excel Programming | |||
Macro to delete last charcter in a text string | Excel Programming |