Guna13
Board Regular
- Joined
- Nov 22, 2019
- Messages
- 70
- Office Version
- 365
- Platform
- Windows
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.
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.
Rich (BB code):
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"
Last edited by a moderator: