Hi Everyone,

I have a problem with an application that I'm running in
Excel 2002 (XP). It seems to be something to do with
different version of Excel.

When I run it in Excel 2002 (10.3506.3501) SP-1 it's fine.

But when I run it in Excel 2002 (10.4109.3501) SP-1 I get
the following error:

'Unable to get the DropDowns property of the Worksheet
class'.

The offending line of code is as follows:

SMode(0) = ActiveWorkbook.Sheets("Predict Input"). _
DropDowns("Drop Down 62").Value

Does anyone know of any reason why this should work in one
version of Excel 2002 but not in another?

Many thanks

Tony Macpherson