Goto a named range/cell

[darbid]

Could someone help me here please.

I want to go to places defined in a sheet.

the first works on my computer but not on another.

The second two do not work yet but think i am on the right track

Please Login or Register  to view this content.

I should add that I am doing this from within access thus the use of object names.

[royUK]

If strcellname is the Named Range

Please Login or Register  to view this content.

[darbid]

If strcellname is the Named Range

Thanks RoyUK

strcellname is not the name but a variable. I have established that the problem is not with the Goto but with the naming.

I use the following to name a cell.

Please Login or Register  to view this content.

Then later to go to that cell

Please Login or Register  to view this content.

Of course I need to used named objects instead of "Application".

But still the goto is not going to the named cell. During debugging I can see that excel has the named/defined cells but simply will not go to them.

One difference is that if I manually name/define a cell in excel the "refers to:" is

Please Login or Register  to view this content.

With my code above my "refers to:" is

Please Login or Register  to view this content.

The stange thing is that on my computer this referencing works but on other computers even though the definitions are made for the cells it just does not go to them. Can anybody suggest a solution.

[royUK]

Try attaching the workbook

[darbid]

not sure that is going to help as it is dynamically created by access VBA.

Here is a cut down version before the code is run. I have deleted other worksheets, you will see this from the insert>define

The second xls is after the naming has happened and before the goto.
On my computer the refers to is correct with $A$7 etc but I am pretty sure this is different on other computers. I will check.

[darbid]

And here is the strange thing.

With the same code as I wrote above to name cells.

You will see in the above two xls the refers to is

Please Login or Register  to view this content.

The below file is the result from another computer. When you look at the refers to it is this...

Please Login or Register  to view this content.

And of course this refers to will not work.

So why does this

Please Login or Register  to view this content.

produce two different results on different computers?

[royUK]

The last line of code adds a Named range to the workbook, but there is no code in the example to check

[darbid]

The last line of code adds a Named range to the workbook, but there is no code in the example to check

Exactly cause I am working from access NOT from excel. But because we are all in an MS Office environment it makes no difference. If you want code here you go.

This is the code setting the names

Please Login or Register  to view this content.

Then this is the code I use later to goto the names places

Please Login or Register  to view this content.

[darbid]

My computer where this code works speaks english.

But the other computers have been speaking german and that is why it has not been working. The code below works for their computer.

Please Login or Register  to view this content.

Z = R
S = C

Any ideas other than getting from the registry what language someone is using?

[royUK]

You could use Application.International to identify the country code, then run country specific code

Please Login or Register  to view this content.

[darbid]

great thanks for english I get a 1.

I actually went and found out what language is in the registry key which is a lot more complicated but worked too.