Populate Range
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
|