Bonjour,
Pour le principe.
Cdlt.
Sub Test()
Dim ws As Worksheet, lastRow As Long, Rng As Range, Rng2 As Range
With ActiveSheet
lastRow = Cells(Rows.Count, "H").End(xlUp).Row
Set Rng = .Cells(2, 8).Resize(lastRow, 3)
End With
On Error Resume Next
Set Rng2 = Rng.SpecialCells(xlCellTypeFormulas, 16)
On Error GoTo 0
If Rng2 Is Nothing Then
MsgBox "Tout est OK"
Else
MsgBox "Erreur", vbExclamation
End If
End Sub