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