This should work... but isn't? (Simple VBA)

[VBAMePlease]

Private Sub CommandButton1_Click()    Sheets("Results").Range("E16").Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlToRight)).Select
    Selection.ClearContents
End Sub

Not sure what I'm doing wrong here, but all I want this to do is go to "Results" sheet, select E16, xlDown & xlToRight and clear the data in that range...

 

[Fluff]

What sheet is your button on?

 

[Norie]

Does this work?

Private Sub CommandButton1_Click()    

    With Sheets("Results")

        Set rng = .Range("E16")

        .Range(rng, rng.End(xlDown).End(xlToRight)).ClearContents

     End With

End Sub

 

[Jonmo1]

I'd recommend writing that without selecting sheets/ranges to begin with.

But for the sake of knowledge, You cannot select a range on a sheet that is not already selected.

this line
Sheets("Results").Range("E16").Select

needs to be broken into 2 lines, to select the sheet first, then select the range
Sheets("Results").Select
Range("E16").Select

 

[VBAMePlease]

Okay, understand now. The button is on "Dashboard" sheet. @Norie that worked for me. Thank you.