Why doesn't "Workbook.Range("myrange").value" work?
 

Thanks Matthew, I didn¹t realise that I needed the ³RefersToRange² part for
it ot work.

Cheers,

Bp.)

in article , Matthew Connor at
mcon__dontneedthis__nor1600@ya__dontneedthis__hoo. com wrote on 8/7/03 2:50
PM:

Personally, I'd go with method 'B' and avoid the Activate command.
To get method 'B' working, try using:
tDataA1 = MyWB.Names("DataA1").RefersToRange.value

(I just asked a similar question sometime last week - Francisco
Mariscal helped me out then.)

Hope this helps,

Matthew