LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
I'd suspect that L is used in a French version for identifying a row
(Ligne). So the french version probably uses L as identifier within the
R1C1 reference style.
So probably no chance to use such a name

--
Regards
Frank Kabel
Frankfurt, Germany

"JSTLB0605" schrieb im
Newsbeitrag ...
Yes, it will work for X1SAVE. But I am hoping that I can find a way

to do
this without having to rename the named region. Renaming it would

have an
impact on many customers and would have to spend a lot of time

updating many
spreadsheets.

"Frank Kabel" wrote:

Hi
does changing the name to X1SAVE work?

--
Regards
Frank Kabel
Frankfurt, Germany

"JSTLB0605" schrieb im
Newsbeitrag

...
I have an application that reads data from spreadsheets based

upon
named
ranges. I have a customer that has ported the application over

to
French
Windows and French Excel XP. The application now gets an error

reading one
of the named ranges, specifically L1SAVE. I now have an

installation
with
French Windows and French Excel XP and have been working in that

environment
to try to figure out why the name will not work. When I go

directly
into
Excel and select the L1SAVE name range I get an error message

indicating that
the name is invalid. I can try to create a new named range with

that
name
and it gives me the same error. I tried varying the name but if

I
give it a
name that begins with L(upper or lower case) with a number other

than
zero
following, I get the error message about it being an invalid

name.
Is there
some special significance to the combination of L and a non-zero

number in
the French version of Excel (maybe related to currency francs?).

If
so how
would I turn off the option that is not allowing these names?




 
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
Setting source data range with Charts D Charts and Charting in Excel 2 January 1st 06 02:51 AM
Sub out of range Jeff Excel Discussion (Misc queries) 1 December 2nd 04 02:21 PM
Achieving Range with a trendline cshdabomb Charts and Charting in Excel 1 December 2nd 04 12:58 PM
Macro for Show/Hide Range Bill Excel Discussion (Misc queries) 3 December 1st 04 05:33 PM
Range in VBA Jeff Excel Discussion (Misc queries) 1 November 26th 04 03:54 PM


All times are GMT +1. The time now is 08:57 AM.

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"