| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Select: current cell + next 19 cells (down in column) = rang
Try this version Dim CrntF As Range Set CrntF = Range("f49:f" & Rows.Count).Find(what:="RELEASED") If Not CrntF Is Nothing Then CrntF.Offset(2, 8).Resize(19).Select End If -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26432 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data: select a cell x rows below the current, where x is designate | Excel Discussion (Misc queries) | |||
| Select all cells in a column up to a blank cell | Excel Programming | |||
| Macro €“ select all cells in current range | Excel Discussion (Misc queries) | |||
| Want macro to select current cell | Excel Programming | |||
| Select current region less one column | Excel Programming | |||
![mudraker[_405_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
