Macro excel97 versus 2000

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved
=IF(ROW(A5:AB272),CALL("Xlcall32","Excel4","2JRJ",74))
The above macro worked perfect in excel 97 I have now been
upgraded to Excel 2000 it now gives a value false as
before when the excel spreadsheet was updated it would
change the date ie 23-Apr. How can I get it to work in
Excel 2000 please.

Thankyou.
 
The CALL function was disabled in Excel 2000 and later versions.
What specifically are you trying to do?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hello Chip from Steved

Chip I would like to use an update
ie any changes made to the spreadsheet in say (A5:AB272)
cells I would like a function in B3 which will Change the
date ie if the value in the cell is 20-Mar, one makes a
change it will change the date to the day they make a
change ie Apr 23. Hope you can find a way round now the
call function is now discontinued as you point out.

Thankyou
 
Back
Top