Hi, I tried to use these code, However, I need the variable that can be
shared among different modules and different workbooks. e.g, I have
written an addin workbook : addin.xla and I declared an array called
arr1() as double.
then I use this array in other sheet to copy the values into this array
from another workbook book1,xls and I find that it doesn't work.

may you help me again? thanks


Desmond

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!