How Can I copy all value of the array into the range?

S

sjoo

Hello Everyone,

I' m trying put an array data into a range as following,

Dim rng As Range
Dim s As Worksheet
Dim arr

Set s = Sheet1
Set rng = Range(s.Cells(1, 1), s.Cells(10, 1))

arr = Array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J")

rng.Value = arr

but All cells of the range is filled with "A".

How Can I copy all value of the array into the range as following,
A1 -> "A"
A2 -> "B"
A3 -> "C"
....
A10 -> "J"

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top