Hi Kirk,

The Mid$ function is not the problem, the problem is (assuming that you
correctly identified the MISSING reference) your reference to the ADO MD
object library. If you remove the Mid$ function VBA will just bomb somewhere
else until you fix this reference problem.

Since ADO is not specific to Excel, you either need to find a machine
with the earliest version of this object library and do your final
Debug/Compile and save there, or you need to update the ADO versions on all
of your machines so that they have the most current version of this object
library. You can download various ADO version updates (referred to as MDAC)
from the following web site:

http://msdn.microsoft.com/library/de...entid=28001860

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Kirk" wrote in message
...
I have a spreadsheet that is used in both XP and XL97.
My problem is that I use the MID$ function to capture
some information. It works fine and dandy in XP, but it
will not work in XL97. The problem is that there is a
newer version of the DLL (msadomd) in XP than in XL97.

I need to be able to determine if the active cell that is
being modified is either the I or the J column. Is there
a way in which I can do this that will work in both XL97
and XP?

Any help would be appreciated. Thanks.

Kirk