LinkBack URL
About LinkBacks
Hello Hke,
This should work.
WksB = gwbB.Names("aName").RefersToRange.Parent.Name
Set wksA = gwbB.Worksheets(WksB)
Sincerely,
Leith Ross
Hello Hke,
This should work.
WksB = gwbB.Names("aName").RefersToRange.Parent.Name
Set wksA = gwbB.Worksheets(WksB)
Sincerely,
Leith Ross
I still get the 1004 error on that first line of code.
debug.print gwbB.Names("aName").RefersToRange.Parent.Name
also makes a 1004
Hello Hke,
Check if WksB contains the Workbook name as well as the Worksheet name by placing a breakpoint in the code next to Set.
Let know,
Leith Ross
Again, thanks for your effort Leith
wksB equals Nothing. It is the first line ,
wksB = gwbB.Names("aName").RefersToRange.Parent.Name
, that makes the 1004 happen.
Could a language incompatibility cause this conflict? I suspect this because the names of the sheets in gwbB are displayed as
"Sheet1 (Sheet1name)"
in the project browser. However, if do a Sheets.Add in some other project I get the norwegian
"Ark1(Ark1)"
in the browser.
Last edited by hke; 05-11-2005 at 11:06 AM.
Hello Hke,
That is certainly a possibility. I didn't realize that this was a multi-lingual setup. Unfortunately, I don't know if or how the code pages could be manipulated to make this work. If you will be using workbooks in both langauges this could be a major obstalce with no easy solutions. Sorry I don't have any other ideas.
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks