Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look for value in a column and delete
You do realise that by filtering on column V, those rows will be exposed
for al columns V-AB? That seems to conflict with your statement '... all exposed cells in V-AB only must be cleared ...' to me. -- HTH RP (remove nothere from the email address if mailing direct) "Tempy" wrote in message ... Hi Bob, Thanks yes that is correct, if column V has #N/A in it then i must clear cells V - AB in that row. In other words if the filter 22 filters for #N/A all exposed cells in V-AB only must be cleared. All other cells in other columns must not be affected. Thanks for the help Bob. Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
delete cells column. Delete empty cells | Excel Worksheet Functions | |||
Delete Every Column After | Excel Programming | |||
Delete All Rows That Column A value is not in Column A of Sheet2 | Excel Programming | |||
Delete a Row if a Certain Value is in Column C | Excel Programming |