| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select and Move based upon keyword
I am trying to find a way to select and move cell values based upon the
originating cell containing a keyword, like "School" or whatever. In the following code, it only finds and moves cells that contain only the word "School". What it I wanted to select and move cells that containted the keyword "School", like "School of Business" or "Agriculture School". I cannot find an object to handle this. Any help appreciated. Pete ================================ Select Case ActiveSheet.Cells(i, k).Value Case "" ActiveSheet.Cells(i, k).Select Case "School" If ActiveSheet.Cells(i, k + L).Value = "" Then ActiveSheet.Cells(i, k).Select ......... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select and Move based upon keyword
Pete
Try the following TestValu = CStr(ActiveCell.Value) IF INSTR(UCASE(TestValu),"SCHOOL") 0 then ' word school is in the cell ELSE ENDIF "PJohnson" wrote: I am trying to find a way to select and move cell values based upon the originating cell containing a keyword, like "School" or whatever. In the following code, it only finds and moves cells that contain only the word "School". What it I wanted to select and move cells that containted the keyword "School", like "School of Business" or "Agriculture School". I cannot find an object to handle this. Any help appreciated. Pete ================================ Select Case ActiveSheet.Cells(i, k).Value Case "" ActiveSheet.Cells(i, k).Select Case "School" If ActiveSheet.Cells(i, k + L).Value = "" Then ActiveSheet.Cells(i, k).Select ......... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to bold a cell based on keyword in another cell... | Excel Discussion (Misc queries) | |||
| Select sheets ina workbook based on radio buttons and move them | Excel Worksheet Functions | |||
| Select & Move Range | Excel Discussion (Misc queries) | |||
| Select rows based on keyword? | Excel Discussion (Misc queries) | |||
| Insert text in Cell A1 based on keyword criteria | Charts and Charting in Excel | |||
Hybrid Mode
