Object Error in excel vba

Question

I am trying to parse data from sheet1 into an array then printing it to another worksheet. I get an object required error, but from what I can gather from msdn is that my object types are wrong for the array but when I switch the array from string to variant I get a mismatch error instead. What can I do to fix the object required 424 error? Here's the code:

Private Sub Enter2_Click()
    'Define Variables
    Dim MatchRow As Integer
    Dim data() As String
    Dim row As Integer
    Dim col As Integer
    Dim dataInfo As String

    Worksheets("Sheet1").Activate
    'Match Name To A Row
    MatchRow = WorksheetFunction.Match(RName.Value, Range("A1:A100"), 0)

    For i = 0 To 22
        Worksheets("Sheet1").Activate
        Cells(MatchRow, i + 3).Select
        data = Split(ActiveCell.Value, ".")

        Worksheets("Reporting template").Activate
        Cells(20, 1).Select
        ActiveCells.Value = data(0)  'This is where the error pops up at
        ActiveCells.Offset(0, 1).Select
        ActiveCells.Value = data(1)
        ActiveCells.Offset(0, 1).Select
        ActiveCells.Value = data(2)
        ActiveCells.Offset(0, 1).Select
        ActiveCells.Value = data(3)
    Next i
End Sub

Omar and Lorraine · Accepted Answer · 2016-11-04 11:34:29Z

1

Is ActiveCells an object you have defined anywhere? Usually to refer to the active cell we use ActiveCell. No s.

answered Nov 4, 2016 at 11:34

Omar and Lorraine

1,2661 gold badge17 silver badges35 bronze badges

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

1 Comment

Dakota Miller Over a year ago

Rofl I must have done that while copying and pasting. Thank you so much!

Collectives™ on Stack Overflow

Object Error in excel vba

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related