Excel 2003 WorksheetFunction Functions run-time error
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
--
Gary''s Student - gsnu200746
"Dave" wrote:
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
|