Convert Excel 4 formula to Excel 2003 format

[Guest]

Hi.

Got this formula defined as a name (Cell has formula):
=GET.CELL(48;INDIRECT("rc";FALSE))
Used it when I had Excel97

Now I have Excel 2003 and get an annoying message that I have an Excel 4 macro
when I open the excel file with this formula. I have checked the file that
it does not have any other macro, so I think this formula is the problem.

How can I convert it to Excel2003 format?

/The Gasell

 

[JE McGimpsey]

See

http://www.mvps.org/dmcritchie/excel/formula.htm#HasFormula

 

[Guest]

I do not know how to use VBA functions.

What I did in the past was:
1. Select: Insert, Name, Define
2. In the define Name Dialog box, I entered the following in the 'Names in
the
workbook' box: CellHasFormula
3. Enter the formula in 'Refers to' box:
=GET.CELL(48,INDIRECT("rc",FALSE))
4. Conditional Formatting (CF)
Fomula is:
=NOT(CellHasFormula)
and made a format to show a yellow cell when I had manually type over a
formula in a cell.

So how can I convert this to Excel2003.


"JE McGimpsey" skrev:

 

[JE McGimpsey]

GET.CELL is an Excel4 Macro command. There is *no* native Excel2003
equivalent, just as there was no native Excel97 equivalent.

In order to extend Excel2003 to provide the function you want, you'll
either need to

- use the Excel4 macro command, and get the warning, or
- use the Excel2003 macro language, which is VBA, or
- write an add-in using VBA or another language.

Those are the only options I see.

For a tutorial on using VBA functions see another page on David
McRitchie's site:

http://www.mvps.org/dmcritchie/excel/getstarted.htm