Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Thanks to you both, you've given me lots of ideas and I have got it working nicely, including a loop that looks for more than one instance by updating the range values. I just wonder - what if you wanted to check 2 adjacent columns ? This fails (so obvously isn't right but I can't think of an alternative, apart from searching twice) theCol = "S2:T100" mt = "RowSRowT" Do With Sheets("Sheet1").Range(theCol) Set rngFound = .Find(What:=mt, _ LookIn:=xlValues, _ LookAt:=xlWhole) If Not rngFound Is Nothing Then r = rngFound.Row End If End With I've set up this test condition Cells(10,"S") = "RowS" Cells(10,"T") = "RowT" Thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to find data from one sheet & copy in another sheet | Excel Programming | |||
Find value in sheet 1 and copy matching row from sheet 2 | Excel Programming | |||
how can find sheet on workbook have so many sheet ? | Excel Worksheet Functions | |||
Find value from sheet 1 on sheet 2 and copy to an offset from there | Excel Programming | |||
how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming |