hi all,
can u tell me how to make use the Excel version, so that i can use it in the code.
i have a piece of code which runs in Excel 2003 but not in Excel 2000. this error is cropping up when i use the errorcheckingoptions
here is that piece of code
' With Application.ErrorCheckingOptions
' .BackgroundChecking = False
' .EvaluateToError = False
' .TextDate = False
' .NumberAsText = False
' .InconsistentFormula = False
' .OmittedCells = False
' .UnlockedFormulaCells = False
' .ListDataValidation = False
' End With
this works well in 2003 but not in 2000 ...please help
rajesh
Bookmarks