Hi!

1)
If I have a name, saved prior a start my macro eg:

MyArray=("Bush","Mitterrand", "Blair")

how can I refer to Myarray(1) from VBA to get the following answer:

MyArray(1)=Miterrand

2)
1)
how can I refer to the value of Screen_Number from VBA.
at the moment I am using this code:

SUB aa()
dim Y
Y=Names("Screen_Number").Value
Y = Mid(Y, 2, 10)
MSGBOX Y
END SUB
"This works but I suppose there is another better way"



Many Thanks!