Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default excel 2003 vba date function not working on all pc's

I use the date function in vba code and on most pc's it's working. However on
a few pc's it's enters break mode and the error message is "undefined
function and "date" is highlighted. ex: currentdate = date will give the
error but only on a few pc's.
thanks for any help
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default excel 2003 vba date function not working on all pc's

I'd start by looking for missing references on the problem pcs.

Inside the VBE with that project active
tools|References
Look for MISSING
if you find any, you'll have to decide if you need it or can just delete it.

If that doesn't work, ...

Look for subroutines/functions that are named Date.
Look for variables called Date.
Look for module names called Date.

(But I'm betting on the missing reference.)

Paul S. wrote:

I use the date function in vba code and on most pc's it's working. However on
a few pc's it's enters break mode and the error message is "undefined
function and "date" is highlighted. ex: currentdate = date will give the
error but only on a few pc's.
thanks for any help


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why would a vlookup function stop working in excel 2003? Patti Excel Worksheet Functions 3 April 30th 09 07:42 PM
Conditional formatting: formula not working on other pc's Mike Excel Discussion (Misc queries) 3 July 23rd 08 01:23 PM
excel 2003 right-click function not working Kel5150 Excel Worksheet Functions 2 January 11th 06 02:21 PM
SendMail Function in Excel 2003 not working properly JonPar Excel Programming 3 June 30th 05 01:46 PM
CHR() function not working in Excel 2003 Richard Jonas Excel Discussion (Misc queries) 4 February 16th 05 08:45 AM


All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"