End process If Formula contains #N/A in Column

[Guna13]

Hi All,

How can I end process If Column From "M:AA" Formula contains any #N/A. also, Please before exit, it will show Exact Row Number & Column Number in MsgBox. Like 8 rows & Z column Like that.

kindly help me.

Sub Validate()

Targ.Select

    If WorksheetFunction.CountIf(Columns("M:AA"), "#N/A") Then
        MsgBox "Error found" ( How can i get it here Exact Row and Column for User Easy Identification ) 
        Exit Sub
    End If
    MsgBox "No errors found"

 

[rlv01]

One way.

    Dim rngFound As Range
    Set rngFound = Range("M:AA").Find(What:="#N/A", LookAt:=xlWhole, LookIn:=xlValues)
    If Not rngFound Is Nothing Then
        MsgBox "#N/A Error found in cell " & rngFound.Address(0, 0)
        Exit Sub
    Else
        MsgBox "No Errors Found"
        Exit Sub
    End If

 

[Peter_SSs]

@Guna13
If you want to highlight specific text in your vba, you need to to use the RICH code tags.

I have changed the tags for you above.

 

[Peter_SSs]

@Guna13
'Mark as solution' should be used only for that. I have removed it from post #3 as that post clearly does not contain a solution to the thread question.

 

[Guna13]

@Guna13
'Mark as solution' should be used only for that. I have removed it from post #3 as that post clearly does not contain a solution to the thread question.

@Peter_SSs - Okay Sir.