| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving to first Instance of a Value
This moves donw from the activecell cell.
do until activecell.value = "" ActiveCell.Offset(1, 0).Range("A1").Select if activecell.value = "Text" then Z= activecell.row end if loop "scott" wrote: I just need to move down column B to find the 1st cell containing a word. Then I'll be able to get it's row and column. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
| How does one name, for instance, A1 as 'last name?' | New Users to Excel | |||
| Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
| First Instance | Excel Discussion (Misc queries) | |||
| How do I get rid of a 2nd instance (xls:2)? | Excel Discussion (Misc queries) | |||
Threaded Mode
