Guten Tag,
ich habe folgendes Makro über dieses Forum erhalten, für das Suchen in den Spalten:
Private Sub CommandButton1_Click()
Dim C As Range
Dim Article As String
Dim Weiter As VbMsgBoxResult
Article = TextBox1
If Article = "" Then Exit Sub
Set C = ActiveSheet.Range("$E$3:$F$650000").Find(What:=Article, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
If Not C Is Nothing Then
C.Select
Else
MsgBox "Not found"
Exit Sub
End If
nochmal:
Weiter = MsgBox("Weitersuchen?", vbYesNo, "Alternative Suche")
If Weiter = vbYes Then
'Set C = ActiveSheet.Range("$C$3:$F$650000").Find(What:=Article, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
Set C = ActiveSheet.Range(C.Offset(1, 0), "$e$650000").Find(What:=Article, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
If Not C Is Nothing Then
C.Select
GoTo nochmal
Else
MsgBox "Not found"
Exit Sub
End If
End If
End Sub
ich möchte gern diese Zeile ebenfalls erweitert haben E+F
Set C = ActiveSheet.Range(C.Offset(1, 0), "$e$650000").Find(What:=Article, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
bin nicht so gut,
mfg wolfgang