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