R1C1 notation in non-English versions of Excel

[ou81aswell]

The following code generates an error when run with the Portuguese (pr-BR culture) version of Excel 2007.

ExcelApp.Goto "R1C1"

The error generated and captured in my app's log file is something like:

"Esta referancia nao a valida"

Is the R (row) and C (column) supposed to be specified differently in different languages?

If so, is there a way to query Excel to ask it what it uses to specify the row and column components of a cell reference?

Thanks!

 

[ou81aswell]

Got it.

The following .NET expression produces "R1C2" in English or whatever's appropriate if Excel is running in a different language.

ExcelApp.International(Excel.XlApplicationInternational.xlUpperCaseRowLetter) & "1" & _
ExcelApp.International(Excel.XlApplicationInternational.xlUpperCaseColumnLetter) & "2"

 

[Marcelo Branco]

Hi,

This worked perfect for me (Excel 2010 pt-Brazilian version)

Application.Goto "R1C1"

M.

 

[ou81aswell]

That may be because you're using VBA. I believe VBA does everything in en-US behind the scenes. .NET is finicky about the culture.

 

[RoryA]

Why not use an actual Range object?

 

[ou81aswell]

Thanks but it's old code and there's lots of it. Unfortunately, I don't have the time to change it.

 

[RoryA]

Looks like you already are having to change it...