Indication that there is a # cell value in the range

  • Thread starter Thread starter avi
  • Start date Start date
A

avi

Hello,

I look for a very fast code that will indicates the presence of at
least one #N/A, #DIV!....in a range the user select

Thanks a lot
Avi
 
One way

Sub merged()
For Each c In Selection
If (IsError(c.Value)) Then
MsgBox "Error at " & c.Address
End If
Next
End Sub


Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Paste a range and shifting away existing data 1
Count no empty cells at the right of a selection 2
Reference named range in closed workbook 23
Copy the contents of a range of cells to a single comment(indicator)? 2
Code to set print range 1
copy a 2 dimensional array to a range 2
Populating a range of empty cells with usernames 4

Back
Top