Excel 2003 WorksheetFunction Functions run-time error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 21 Sep 2007 17:08 GMT

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

Reply to this Message

Gary''s Student - 21 Sep 2007 18:40 GMT

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

Signature

Gary''s Student - gsnu200746

> 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
[quoted text clipped - 11 lines]
>
> Dave

Reply to this Message

Dave - 24 Sep 2007 16:54 GMT

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.

> 1. find a computer with VBA working to your satisfaction
> 2. in VBA pull down:
[quoted text clipped - 20 lines]
> >
> > Dave

Reply to this Message