i have written a basic set of macros that DDE connects to another application, grabs an array, and writes it to a range(some).FormulaArray.

why is it that , i modify the servername, and i restart excel, i am able to receive the new array, but now the array will not write onto range(some).FormulaArray..insetad it will still have the previous run's servername in its formula field, printing #REF! all across the specified range(some)....

i cannot delete the array, by running another macro doing

range(some).FormulaArray = "="

does excel behave differently when u save and run things ?

or should i be writing vba macros in a new module intead of the worksheet.

if im writing in macros in new module, how can i access the sheet ?

Worksheets("Sheet1").Range("some").FormulaArray ?