Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a line of code only that only fails when the public variable "cell"
has an error statement in it (i.e. Div/0, REF# #####, NAME! etc). The variable is dimensioned as a Range. As I am simply pulling the variables address proptery and Parent Name into the Match, why would these error statements matter? The idea below is that if the Match fails, i error handle it with the ISERROR sttm. Yet the actual cell errors in the spreadsheet itself seem to make this line of code fail. Why is that? Thanks Not IsError(Application.Match(cell.Parent.Name & "!" & cell.Address, UniqueCellAddressArray3, 0) - 1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX / MATCH Formula Errors | Excel Discussion (Misc queries) | |||
Value errors in Match function | Excel Worksheet Functions | |||
Match name, value & identify errors | Excel Discussion (Misc queries) | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions | |||
add-in macro strange errors--method sheets of object workbook fail | Excel Programming |