Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
and once again , i forgot to reply to your main question...
instead of a loop, if you need to find the first instance of item2 in destWB, you could use the FInd method of the Range object: Dim rg As Range, item2 as string, rg as range .. .. .. 'search in whole column E Set rg = destWB.Worksheets("Sheet1").Range("E:E").Find(item 2, , xlValues, xlWhole) If rg Is Nothing Then MsgBox "not found" Else MsgBox "found at " & rg.Address End If -- Regards, Sébastien <http://www.ondemandanalysis.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a Workbook based on a Cell information in another Workbook | Excel Worksheet Functions | |||
Finding error messages in a workbook | Excel Programming | |||
finding all link, hyperlinks in a workbook | Excel Discussion (Misc queries) | |||
Finding out if subroutines exist in another workbook | Excel Programming | |||
Finding duplicate value in another workbook | Excel Programming |