Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Help: Excel 4 macro suddenly no longer working

I have Excel 2000 under Win 2000, running spreadsheets containing a
(big) Excel 4 macro in a separate sheet.
It has worked for 2 years now without a problem.

Suddenly, it does not work any more.
The macro stops and reports an error when it meets an instruction of
the following type: =SELECT("INDEX(recdat;1;1)")
("recdat" is a user-defined array , "SELECT" is tentatively translated
from French "SELECTIONNER"))

In other words, this instruction is no longer recognized by the Excel
macro interpreter.
I have done alls sorts of changes to my system lately, mostly
related to the Internet, but I have lost track of all these changes.

Is there someone who could guess what kind of change to my
Excel - or to my Windows 2000 - could have caused this problem?

Incidentally, I have another instance of Win 2000 with Excel 2000 on a
different partition of this machine, which I am not using often (and
not "updating"). There, it still runs fine.....

Thanks for any hint or suggestion

KS

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
My formulas in excel are suddenly not working. Help! mathteacher Excel Worksheet Functions 5 April 26th 08 08:08 AM
Keyboard Shortcuts in Excel 2002 suddenly quit working Tapioca Excel Worksheet Functions 1 September 4th 07 04:05 AM
My Excel freezes suddenly while working marwin Excel Discussion (Misc queries) 1 April 12th 06 03:10 PM
HELP!! Macro suddenly not working onedaywhen Excel Programming 0 February 9th 04 10:41 AM
HELP!! Macro suddenly not working rodt[_2_] Excel Programming 0 February 7th 04 06:28 AM


All times are GMT +1. The time now is 12:59 PM.

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

About Us

"It's about Microsoft Excel"