NewDaddy
03-01-2007, 03:26 AM
Hi All
Most likely a very simple question but cannot fathom this?
Range("C1:C4").Value = Array("North", "South", "West","East")
Why does the above return "North" in cells C1:C4 and not the following?
C1 - North
C2 - South
C3 - West
C4 - East
The above works fine when the range is C1:F1. How can I get the above 'headings' to return in C1 to C4?
Thanks for the explanation and solution.
Cheers
Jay
Most likely a very simple question but cannot fathom this?
Range("C1:C4").Value = Array("North", "South", "West","East")
Why does the above return "North" in cells C1:C4 and not the following?
C1 - North
C2 - South
C3 - West
C4 - East
The above works fine when the range is C1:F1. How can I get the above 'headings' to return in C1 to C4?
Thanks for the explanation and solution.
Cheers
Jay