| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete row if cell starts with ...........
I have a couple of values in Column 1 where there are values that start with
PJR. I would like to delete the whole row if a cell contains a value that starts with PJR. I would be grateful if you could provide me a Macro that would do just this. Many Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200605/1 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Delete row if cell starts with ...........
You have some examples with code in this page:
http://www.rondebruin.nl/delete.htm "mohd21uk via OfficeKB.com" wrote: I have a couple of values in Column 1 where there are values that start with PJR. I would like to delete the whole row if a cell contains a value that starts with PJR. I would be grateful if you could provide me a Macro that would do just this. Many Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200605/1 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Delete row if cell starts with ...........
Another option is to use EasyFilter to do this
http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Miguel Zapico" wrote in message ... You have some examples with code in this page: http://www.rondebruin.nl/delete.htm "mohd21uk via OfficeKB.com" wrote: I have a couple of values in Column 1 where there are values that start with PJR. I would like to delete the whole row if a cell contains a value that starts with PJR. I would be grateful if you could provide me a Macro that would do just this. Many Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200605/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Delete row based on contents of cell | Excel Discussion (Misc queries) | |||
| if cell starts with characters formula | Excel Discussion (Misc queries) | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
Hybrid Mode
