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