When K22 contains "QS" and there is data in column M a message will appear.

If WorksheetFunction.CountA(Range("M28:M1000")) = _
WorksheetFunction.Count(Range("M28:M1000")) Then
If Cells(22, 11).Value = "QS" Then
MsgBox "There is data in column M28:M1000, find and delete this
data "
Exit Sub
End If

The problem I am encountering is that any data appearing in column M is the
result of a formula. How can I have the code ignore the formula and only
recognize the result of the formula.

Thanks
Pat