Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's my example:
2006 2006 2005 2005 2004 2004 Name you(me) you you(me) you you(me) you I want to delete the columns that the names are "you(me)" I write the code as follows: for i=1 to 6 if cells(2,i)="*me*" then columns.select selections.delect i=i-1 end if next i but nothing changed when I run the code what's wrong with that? is it proper for me to use cells(2,i)="*me*" to find anything that has the string"me"? thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
Delete selected sheet | Excel Programming | |||
delete every nth row in selected range | Excel Discussion (Misc queries) | |||
delete columns and rows-cells equalling zero or any selected value | Excel Worksheet Functions | |||
Delete Selected Rows | Excel Programming |