Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2003 WorksheetFunction Functions run-time error
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 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2003 WorksheetFunction Functions run-time error
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. "Gary''s Student" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004 When running in 2003 | Excel Discussion (Misc queries) | |||
Worksheetfunction.vlookup and #value error | Excel Worksheet Functions | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
M/S Visual C++ Run Time Error when attempting to use functions | Excel Worksheet Functions |