LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default VBA code erroring in XL97...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Not Erroring with List OyBouTJ Excel Worksheet Functions 2 June 4th 08 06:33 AM
Custom Command Bar Erroring out when distributed Bret Excel Programming 1 February 14th 06 11:39 PM
VBA for XL97 dipitiduda Excel Programming 1 January 18th 06 08:20 PM
Excel Erroring on Close Denny Behnfeldt Excel Programming 1 February 22nd 05 02:19 AM
Code runs in XL97 but not 2000? Brian Excel Programming 1 April 7th 04 03:21 PM


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"