| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
locate cell with specific text and select that column
First click on a cell in the row you want searched and then run:
Sub get_col() s = "happiness" n = ActiveCell.Row For i = 1 To Columns.Count If Cells(n, i).Value = s Then Cells(n, i).EntireColumn.Select End If Next End Sub to find happiness. -- Gary''s Student - gsnu200796 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select specific text in cell | Excel Discussion (Misc queries) | |||
| Select specific column for auto filter | Excel Worksheet Functions | |||
| How do I select cells within a column that contain a specific word | Excel Worksheet Functions | |||
| Locate a specific row or column | New Users to Excel | |||
| Select cell containing specific text &return value from another ce | Excel Worksheet Functions | |||
Threaded Mode
