Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection of range
Hello All,
The following is the arrangement of a row. 25,26,27,28,29,30,25,26,27,28,29,30 The arrangement changes to 25,26,28,30,25,27,30 ( not on proper sereis) when I refresh the data. I would like to select the'range' from 25 to 30 always(first sereis only).Is automatic selection of a range possible based on the above or similar condition. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection of range
This is rude and crude. And it is set for row 1
=========================================== Dim ad As String Range("A1").Select ad = Cells.Find(What:="30", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) _ .Address ad = "A1: " & ad Range(ad).Select ======================================= This one might work for a row defined by a variable Dim ad As String, r as Long r = ??? ' need to define r Cells(r,1).Select ad = Rows(r).Find(What:="30", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) _ .Address ad = "A1: " & ad Range(ad).Select ========================= -- sb "me" wrote in message ... Hello All, The following is the arrangement of a row. 25,26,27,28,29,30,25,26,27,28,29,30 The arrangement changes to 25,26,28,30,25,27,30 ( not on proper sereis) when I refresh the data. I would like to select the'range' from 25 to 30 always(first sereis only).Is automatic selection of a range possible based on the above or similar condition. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA - Selection Instead of Range | Excel Discussion (Misc queries) | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Range Selection | Excel Discussion (Misc queries) | |||
Selection Range | Excel Discussion (Misc queries) |