Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 VB referencing #N/A not working but works in Excel 2007
I have a very simple macro that works in Excel 2007 but hangs up constantly
in Excel 2003. Does anyone have a work around? Problem: 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 Further background.... I am actually wanting to find #N/A values to turn "off" the data labels in a stacked bar chart if they are #N/A. In Excel 2007, this is not even required because it won't put #N/A values on the chart, but Excel 2003 will continue to show them on the chart as 0 value which clutters up the chart. My macro just checks the value and if a value turns on the data label and if #N/A turns off the data label. Again, macro works perfectly in Excel 2007 but I need to give to users who still have Excel 2003. Thanks for help |
#2
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 |