| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code using Find to locate text and display the Cell Range.
Thanks that's what I need.
"LabElf" wrote: I think I can answer part of your question. To get the row and column of your active cell, you coud use: iColumn = ActiveCell.Column iRow = ActiveCell.Row I don't know what you mean by "the cell 10 below plus 10 cells down", but if you want to access the cell 10 rows below the active cell and the same column, you could use: ActiveCell.Offset(10, 0) If you want to select the range from the active cell to the cell 10 rows below, you could do: Range(ActiveCell, ActiveCell.Offset(10, 0)).Select Does that help? -- Assigning guilt doesn't solve the problem "slimla" wrote: Actually, What I'm trying to achieve is selecting the Range from a Activecell to a specfic number. Since my Activecell is not constant, that why I have to first use the Find Function then select the cell 10 below plus 10 cells down and copy and paste it somewhere else. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display text in a cell in a range of cells | Excel Discussion (Misc queries) | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| How can I display a cell range in a text box in excel? | Excel Discussion (Misc queries) | |||
| VBA code to locate cell address of AutoFilter dropdown box | Excel Discussion (Misc queries) | |||
Hybrid Mode
