Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wrote some VBA code in XL 2003. when the form was emailed to a 3rd
party using XL97 it errored. I understand that XL97 uses VBA 5.0 and that it will not recognize functions that were added in VBA 6.0. Here is the code section that is erroring For Each i In Range("A71:A74, A77:A80, A83:A86, A89:A92, A95:A98, A101:A104") For Each n In Range(Cells(i.Row, 2), Cells(i.Row, 7)) If n.Value = "0" Then Application.EnableEvents = False Range(Cells(i.Row, 2), Cells(i.Row, 7)).Interior.ColorIndex = xlColorIndexNone Cells(i.Row, 11).ClearContents Application.EnableEvents = True GoTo NXTROW It errors on the line.........If n.Value ="0" Any Ideas? Thanks Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation Not Erroring with List | Excel Worksheet Functions | |||
Custom Command Bar Erroring out when distributed | Excel Programming | |||
VBA for XL97 | Excel Programming | |||
Excel Erroring on Close | Excel Programming | |||
Code runs in XL97 but not 2000? | Excel Programming |