how to make array of cells in vba excel

Question

I want to make array of cells in excel to using VBA to add new row, I used this code

Private Sub add_Click()
Sheets("Block B").Range("C8").Select
ActiveCell.EntireRow.Insert Shift:=xlDown Sheets("Block B").Range("C8:L8").Select  Selection.Borders.Weight = xlThin

But the new line insert in exact raw 8, I want in each click to add a new row in the next row 8, 9, 10, ...

How can I do it ?

Repeat it for the other two but do it in the order of 10, then 9, then 8 — Marcucciboy2
– Marcucciboy2, Commented Sep 29, 2018 at 20:04
You want to click a button and insert a new row at a specific row, and for each subsequent click to move down and insert a new row at the next row. View this SO question — GMalc
– GMalc, Commented Sep 30, 2018 at 0:06

Dy.Lee · Accepted Answer · 2018-09-30 00:54:01Z

0

We must turn the circulation from a lot to a small one.

Try this

Sub test()

    Dim Ws As Worksheet
    Dim i As Long

    Set Ws = Sheets("Block B")
    With Ws
        For i = 10 To 8 Step -1
            .Range("c" & i).EntireRow.Insert
            .Range("c" & i).Resize(1, 10).Borders.Weight = xlThin
        Next
    End With
End Sub

answered Sep 30, 2018 at 0:54

Dy.Lee

7,5471 gold badge14 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to make array of cells in vba excel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related