about Array

[idnoidno]

　
100
20
10


　
100
20
10


A
1
12
　


A
1
12
10


B
　
　
5


B
100
20
5


C
　
15
　


C
100
15
10


D
50
　
　


D
50
20
10





I would like to use EXCEL VBA ARRAY way, let the blank form on the left side of the table to fill in the top of the value, into the right form, if someone can help, I will be very grateful.

[YasserKhalil]

Try this code

Sub Test() Dim arr As Variant
Dim i As Long
Dim j As Long

arr = Range("A1").CurrentRegion.Value

For i = 2 To UBound(arr, 1)
For j = 2 To UBound(arr, 2)
If arr(i, j) = "" Then
arr(i, j) = arr(1, j)
End If
Next j
Next i

Range("G1").Resize(UBound(arr, 1), UBound(arr, 2)).Value = arr
End Sub

[YasserKhalil]

Cross-Post at this link
http://chandoo.org/forum/threads/how-to-copy-fixed-values-into-the-blank-cells.34048/

[idnoidno]

Thank you very much for your reply, I will study it carefully.
If there is a problem, can I ask you?

[idnoidno]

If I fill in the blank cell on the left side of the table, how to modify it? Thanks.

[YasserKhalil]

You're welcome
Try change this line


arr(i, j) = arr(1, j)
To

arr(i, j) = arr(i, 1)

[idnoidno]

Thank you very much. I have found this little correction.

[YasserKhalil]

You're welcome. Glad I can offer some help

[idnoidno]

Hi,I would like to ask for no excel vba professional background of the people, to learn vba, what kind of advice you will give?

[YasserKhalil]

Try to read books for beginners so as to be able to follow. You can watch Youtube channels such as WiseOwl Channel and other channels
And the most important is to try to apply what you learn and follow the forums too

[idnoidno]

May I ask you a question?
myarr=Range("a3", Range("a2").End(xlDown).End(xlToRight))
IF a3 is replaced by a2，what is the difference?

[YasserKhalil]

I think there is no difference .. but if you intend to store that range in array, you would put at the end .Value

[idnoidno]

Excuse me, May I ask that what are the occasions to use this syntax of xlToRight and xltoLeft?

[YasserKhalil]

In normal direction of columns A, B , C and so on you use XlToRight ... and if the vice versa you use XlToLeft
Try recording Ctrl + right arrow & Ctrl + Left arrow