Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
possible? =if(That cell = "a certain word", delete row, go next)
Can Conditions include operative actions if true or false? such as:
If cell A7 = "Smith", delete row if yes, go to next cell if no ??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
possible? =if(That cell = "a certain word", delete row, go next)
Jim
No, functions can only return a value, you will need a macro if you want automated actions -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Jim" wrote in message ... Can Conditions include operative actions if true or false? such as: If cell A7 = "Smith", delete row if yes, go to next cell if no ??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
possible? =if(That cell = "a certain word", delete row, go next)
Jim,
You need to use VBA to do this. Deletes any row containing Smith in column A .... must start at last row and work upwards Sub DeleteRow() e.g For r = 100 to 1 step -1 If cells(r,1)=Ucase("Smith") then cell(r,1).entirerow.delete End if Next r End sub "Jim" wrote: Can Conditions include operative actions if true or false? such as: If cell A7 = "Smith", delete row if yes, go to next cell if no ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete a cell if it contains specific word | Excel Discussion (Misc queries) | |||
VBA Excel Macro to delete contents in named cell | Excel Discussion (Misc queries) | |||
How do I delete the automatically inserted ' in every Excel cell? | Excel Discussion (Misc queries) | |||
How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) |