Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm having at least 2 problems with the following code:
Set wCtyLstSht = Workbooks("Mark Top 10.xls").Worksheets("Sheet1") Set wTrgtSht = ActiveSheet Set rCtyLst = wCtyLstSht.Range("C2:C11") sCtyCol = InputBox("Please enter the column where the counties are currently listed", _ , "A") sColMrk10 = InputBox("Please enter the column to mark the Top Ten Counties") ' TEST for county numbers/names or names For Each rCell In rCtyLst wTrgtSht.Activate Set rFndCell = Cells.Find(What:=rCell, After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False) If Not rFndCell Is Nothing Then rCtyMrkr = wTrgtSht.Range(Cells(rFndCell.Row, sColMrk10)) <---ERROR rCtyMrkr = "y" End If Next End Sub Range method is failing at the marked place. Can't figure out why. A watch on rCell shows it is blank, but cell C2 in that worksheet contains the text ADAMS (which is the value that I want to search the other sheet for). Any ideas? Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select Method Failing | Excel Programming | |||
Publish method failing, can't understand why | Excel Programming | |||
Excel Copy Method Failing. | Excel Programming | |||
select method of range class failing ? | Excel Programming | |||
add method of validation failing | Excel Programming |