P
Peter T
change -
to -
.Names.Add Name:="ArrTemp", RefersToR1C1:=Array(A, B, C, D, E, F, G, H, I,
J)
or
dim vArr as variant
varr = Array(A, B, C, D, E, F, G, H, I, J)
.....refersto:=vArr
Regards,
Peter T
.Names.Add Name:="ArrTemp", RefersToR1C1:="={A,B,C,D,E,F,G,H,I,J}"
to -
.Names.Add Name:="ArrTemp", RefersToR1C1:=Array(A, B, C, D, E, F, G, H, I,
J)
or
dim vArr as variant
varr = Array(A, B, C, D, E, F, G, H, I, J)
.....refersto:=vArr
Regards,
Peter T