Excel 2003 WorksheetFunction Functions run-time error

[Dave]

Excel 2003 Basic edition came pre-installed on an XP desktop and laptop.
On the laptop, Get a run-time error from VBA saying that none of the
WorksheetFunction.xxxxx, where xxx is any Excel function (e.g., Find), could
be found. This problem doesn't occur on the desktop box.

I tried re-installing Office from the disk that came with the laptop. While
I was
doing that, Office SP3 started installing itself. When both had completeld,
all Macro functionality was.

How do I get out of this mess? I'd like to end up with SP3 installed
properly and
with all VBA functionality operable.

Dave

 

[Gary''s Student]

1. find a computer with VBA working to your satisfaction
2. in VBA pull down:
Tools > References
and note which references have been checked

3. on your new computers, establish/confirm the same reference configuration
4. exit Excel
5. re-enter Excel and see if things have improved

 

[Dave]

Thanks a lot for your advice. A definite improvement!

Most everything is now working - except for the WorksheetFunction.xxxxxx
code. I've verified that the VBA Tools/References are ok - the VBA-related
ones are checked.

Any suggestions greatly appreciated.