Invalid name Error

[fujing1003]

Dear Friends,

We are generating reports in Excel 2003 .

one of our reports having Invalid name Error in Excel 2003.

the name's formula is as follows, =GET.CELL(7,InputData!$C
$63)&T(NOW())


But when we used Excel xp for generating reports we had no

errors. can you help me to solve this problem .

 

[Joel]

The instruction makes noo sense at all. If it ws a worksheet function then
"get.cell" is not valid. There is no such thing as GET in a workshet
function and the period between two items again is not valid.

If you were doing a VBA instruction like

Data = "=GET.CELL(7,InputData!$C$63)&T(NOW())"

Ther is no such thing as Get. CELL should be CELLS. And

InputData!$C$63 should be sheets("InputData").Range("C63")

 

[Dave Peterson]

Maybe it was the name, not the formula that caused the trouble.

I create a (valid) name in xl2003 using that formula and it worked fine.

 

[Dave Peterson]

This is one of the old xlm macro commands.

These can be used in code or in names.

http://www.microsoft.com/downloads/results.aspx?freetext=Macrofun

You can read more about them by getting both of these:
Macrofun.exe & Macro97.exe (which contains XLMacr8.hlp)

You may have trouble with macrofun.exe, but macro97.exe creates a .hlp file.

And to me, it sure looks like the content is the same.