Code for dealing with #REF
I gave you a worksheet formula because it wasn't clear to me whether you
were writing code or writing formulas.
While I'm still not sure what you're doing, you can check a cell like this
for an error value:
If IsError(Cells(RowToFind, ColToFind).Value) Then
MsgBox "Error"
End If
or like this:
If IsError(Range("C9").Value) Then
MsgBox "Error"
End If
Or with its range name if you've assigned one.
--
Jim
"Kevin Porter" wrote in message
...
| How would I use it when using variables. I am using RowToFind and
ColToFind
| earlier in the code. But when I try to replace (A1:A10) in the code with
| those variables it does not recognize them, of course. I have been
playing
| with it since your response and not making much headway.
|
| Thanks for your help.
|
| "Jim Rech" wrote:
|
| You can trap REFs or any kind of errors in cell values like this:
|
| =IF(ISERROR(SUM(A1:A10)),0,SUM(A1:A10))
|
| Excel 2007 has a shorter form:
|
| =IFERROR(SUM(A1:A10),0)
|
| You'd of course replace the 0 with another formula.
|
|
| --
| Jim
| "Kevin Porter" wrote in message
| ...
| |I have some fields that end up #REF because of deletes that are done.
I
| | would like to look at that field, if it contains #REF then I want that
| field
| | to be the sum of all the columns in that row. If it doesn't then I
want
| it
| | to equal what it equals.
| |
| | Thanks,
| |
| | Kevin Porter
|
|
|
|