AW: Makro höchsten Wert ermitteln und markieren
12.12.2023 12:02:52
hary
Moin nochmal
Hier mal mit Makro. Teste mal.
Sub Max_Test()
Dim rngFind As Range
Dim erste As Long
Dim firstAddress As String
With Columns(13)
Set rngFind = .Find("Ergebnis", LookIn:=xlFormulas)
If Not rngFind Is Nothing Then
firstAddress = rngFind.Address
Do
erste = Cells(rngFind.Row, 13).End(xlUp).Row
rngFind.Offset(, 1) = Application.Max(Range(Cells(erste, 13), Cells(rngFind.Row - 1, 13)))
Set rngFind = .FindNext(rngFind)
Loop While rngFind.Address > firstAddress
Else
MsgBox "No results"
End If
End With
End Sub