| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 VB referencing #N/A not working but works in Excel2007
KMH wrote:
When referencing cells that have a #N/A value, Excel 2003 craps out even if I use the ISNA application function before it. The following 2 statements will cause Excel 2003 VB to stop regardless of order if the cell that is referenced comes up with #N/A. * * * * * * Series = Cells(RowNumStart + X - 1, SeriesCol).Value * * * * * * If WorksheetFunction.IsNA(Cells(RowNumStart + X - 1, ColNum)) Then Works fine for me, I just wrote a quick test case that calls IsNA(1,2) and throws up a MsgBox and it works, are you sure that statement is the one that's hanging? Phil Hibbs. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Right-Click not working in Excel 2007. Works in other Office 07 pr | Excel Discussion (Misc queries) | |||
| SUMIF formula works in Excel 2003, does not work in Excel 2007 | Excel Discussion (Misc queries) | |||
| function =IFERROR LOOKUP works in excel 2007 not in excel 2003 | Excel Worksheet Functions | |||
| Automation C++ code works for Excel 2003, not for Excel 2007 | Excel Programming | |||
| Clear borders macro not working in Excel 2007 but works fine in 20 | Excel Programming | |||
Hybrid Mode
