Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
silly (?) problem defining ResultRange
Hello everyone over here, I'm new here and hope someone can help. I have written VBA that collects info from a ResultRange in other docs. Worked fine, untill I made a new lay-out for the doc and I tried to define the ResultRange again, think I'm missing out on something... In this case it works fine: [image: http://www.heup.info/dagboeken_verha...s/correct.jpg] in this case it doesn't work... [image: http://www.heup.info/dagboeken_verha...incorrect.jpg] :roll: drives me crazy, must be something silly.... I select the row (70) define the name and no way... Is it something to do with '1-R' missing in the second case... I can't get it there... Brit -- britvos ------------------------------------------------------------------------ britvos's Profile: http://www.excelforum.com/member.php...o&userid=25246 View this thread: http://www.excelforum.com/showthread...hreadid=387373 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
silly (?) problem defining ResultRange
Brit,
I think you are trying to use the same range name to define two different ranges. You need to make each name sheet specific. When you type in the name, prefix it with the sheet name. In your case '1-S'!ResultRange and '1-R'!ResultRange Fred "britvos" wrote in message ... Hello everyone over here, I'm new here and hope someone can help. I have written VBA that collects info from a ResultRange in other docs. Worked fine, untill I made a new lay-out for the doc and I tried to define the ResultRange again, think I'm missing out on something... In this case it works fine: [image: http://www.heup.info/dagboeken_verha...s/correct.jpg] in this case it doesn't work... [image: http://www.heup.info/dagboeken_verha...incorrect.jpg] :roll: drives me crazy, must be something silly.... I select the row (70) define the name and no way... Is it something to do with '1-R' missing in the second case... I can't get it there... Brit -- britvos ------------------------------------------------------------------------ britvos's Profile: http://www.excelforum.com/member.php...o&userid=25246 View this thread: http://www.excelforum.com/showthread...hreadid=387373 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Silly Problem with Variable (2nd attempt) | Excel Discussion (Misc queries) | |||
This is so silly... | Excel Worksheet Functions | |||
Problem defining Freese Panes setting | Excel Worksheet Functions | |||
Syntax problem in defining OnAction macro definition held in Add-in! | Excel Programming | |||
Silly I know | Excel Programming |