none
object required error RRS feed

  • Question

  • hi,

    I have the following excel VBA code which throws an error called Object required. Please someone help me solve this.

    Sub Button1_Click()
    If Range("a1").Value = " " Then
    Range("a1").Activate
    Else
    Range("a1").CurrentRegion.Select
    Range("a1").Offset(Selection.Row.Count, 0).Activate
    End If
    End Sub

    Thank you

    Monday, December 30, 2013 10:54 AM

All replies