Addressing Named Formula Array

[UKSteveM]

Hi All,

I have a named formula in excel, "OIBudget" with budget numbers for a year. In the VBA environment i create an array variable OIBudgetArray, with the following code;

OIBudgetArray = range("OIBudget").value

Works great, lets me do the necessary work and referencing which i need to for the program. Problem is i need to reference this from Word, i'm driving the VBA from Word, when i use the same syntax it fails to compile, any ideas as to why?

I have tried referencing the range explicitly but I cannot get it to work successfully.

Cheers,

Steve

 

[UKSteveM]

Fixed it, i had named my array the same as the named formula, this seems to be the cause. I have renamed the array variable and it works.