Brianwarnock
Retired
- Local time
- Today, 23:43
- Joined
- Jun 2, 2003
- Messages
- 12,701
Match can be used to return the row number when searching in 2 column,( normally it would have Index wrapped round it.)
=MATCH(A1&B1,(Sheet3!D$1$7)&(Sheet3!F$1:F$7),0)
edit that Damn smilie should be : D
but I could not replicate this in VBA where I kept getting
Run Time error '13'
type mismatch
I coded
anybody any ideas?
Brian
=MATCH(A1&B1,(Sheet3!D$1$7)&(Sheet3!F$1:F$7),0)
edit that Damn smilie should be : D
but I could not replicate this in VBA where I kept getting
Run Time error '13'
type mismatch
I coded
Code:
Dim myrow2 as Long
myrow2 = Application.WorksheetFunction _
.Match(Sheets("sheet1").Range("A1") & Sheets("Sheet1").Range("B1"), Worksheets("sheet3").Range("d1:d7") & Worksheets("sheet3").Range("e1:e7"), 0)
anybody any ideas?
Brian
Last edited: