Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
starting from bottom of range instead of top
I wrote the following code:
Set wsCtyLst = Workbooks("Mark Top 10.xls").Worksheets("CtyLst") Set wsSrc = ActiveSheet 'sWhichTop = _ 'InputBox("Please enter 10 or 21 to determine which counties you want extracted", , 10) 'REPLACE with code to determine which table to use Set rCtyLst = wsCtyLst.Range("C2:C11") Workbooks("Mark Top 10.xls").Activate wsCtyLst.Select rCtyLst.Select Workbooks("Top Ten Extract Test.xls").Activate sCtySrcCol = InputBox("Please enter the column where the counties are currently listed", _ , "A") sColMrk10 = InputBox("Please enter the column to mark the Top Ten Counties", "E") 'TEST for valid entries on both variables 'TEST sColMrk10 for existing data ' TEST for county numbers/names or names With wsSrc Set rCtySrc = .Range(.Cells(2, sCtySrcCol), _ .Cells(2, sCtySrcCol).End(xlDown)) End With wsSrc.Select rCtySrc.Select Set rFndCell = Cells.Find(What:=rCtyLst, _ After:=ActiveCell, _ LookIn:=xlValues, _ LookAt:=xlPart, _ SearchOrder:=xlByColumns, _ SearchDirection:=xlNext, _ MatchCase:=False) I want it to start searching rCtySrc using the first value in rCtyLst, but it uses the last value. How to I tell it to search from the top down? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA for COUNTING #S STARTING WITH A 4 IN A RANGE 1 TO 100,000 | Excel Worksheet Functions | |||
Dynamic chart that displays a range starting today | Charts and Charting in Excel | |||
Scroll bar starting at bottom of form | Excel Programming | |||
Scrollbars starting at the bottom of form | Excel Discussion (Misc queries) | |||
How to: Add blank row at bottom of range | Excel Programming |