silly (?) problem defining ResultRange

[britvos]

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:

\1

in this case it doesn't work...
\1

: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

[Fred]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>