Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range of a Find object
I use Cells.Find to locate a column. How do I select a certain range
within the column of the found range? '-------------------Here is the dumbed down version of the code: Set testrng = Cells.Find(What:="Selections", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) If Not testrng Is Nothing Then Selection.copy I know this selects the whole column: testrng.EntireColumn.Copy I want to be able to do this: Range(testrng.column & "65536").end(xlup). (offset(1,0).copy '(or paste) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a range of a Find object | Excel Programming | |||
Selecting Drawing Object By Name | Excel Programming | |||
Range Object with Find and Offset | Excel Programming | |||
Selecting object | Excel Programming | |||
Selecting cells which do not meet a formatting criteria, and assigning a Range object to these. | Excel Programming |