Hi Don Guillett,

If i were to provide you the excel file with those Lotus macro, are you able
to help me to convert them as vba ?

Best Regards,
Chong

"Don Guillett" wrote:

Looks like you need to change toolsoptionstransition
or vba

range("e12")=0
range("e13")=1
range("e11")=range("b1")
range("e14")=1
range("e11")=range("e11")-range("e13")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chong" wrote in message
...
I have an Excel 97 with the following coding in the cell. By press Ctrl-A,
the formula will be calculated accordingly. But when i open this file in
Excel 2003, it doest function anymore after i press Ctrl-A. Please help.

{LET E12,0}~
{LET E13,1}~
{LET E11,B11}~
{LET E14,1}~
{LET E11,E11-E13}~