What´s wrong with this? And, is there a way to populate a range in one
line code? Thanks in advance.


Sub Test
Range("E1:F3").value = Array(1,2,3,4,5,6)
end sub

It takes 2 lines:
Sub Test()
Range("E1:F3").FormulaArray = "={1,2;3,4;5,6}"
Range("E1:F3").Formula = Range("E1:F3").Value
End Sub
Bob Umlas
Excel MVP

"Fabio" wrote in message
oups.com...
What´s wrong with this? And, is there a way to populate a range in one
line code? Thanks in advance.


Sub Test
Range("E1:F3").value = Array(1,2,3,4,5,6)
end sub

Thanx a lot

Bob,

Actually the first pair is string
"={"Word1","Word2";1,2;3,4}"

Any help?