Sheet to sheet copy

[vba-lover]

Dear Experts

I want to copy sheets("Table") to sheets("View")

But before copy: I want to clear contents of target sheet range("a3:z1000")

I wrote following procedure but it shows error message 1004.

Please help

Private Sub CommandButton7_Click()

Sheets("View").Select
Range("A3:H1000").Select
Selection.ClearContents

Sheets("Table").Select  ' source sheet
Range("A:Z").Select
Selection.Copy
    
Sheets("View").Select   'Target sheet
Range("A3").Select
ActiveSheet.Paste
Columns.AutoFit
  
End Sub