Clearing Contents Of Cells

Hello,

My computer runs on Excel 2003 but my Laptop is on Excel 2000, the problem is I have the below code on a spreadsheet I wrote on my Computer which runs fine but when I open it on my Laptop it comes up with a run time error it doesn’t like the clear contents line.

If some one could explain to me why it is happening and how to get round the problem so it will work in Excel 2003 and 2000 that would be much appreciated.

Thanks

Nathan

Private Sub Workbook_Open()


Application.ScreenUpdating = False


Sheets("data").Visible = xlVeryHidden
       
Sheets("Incidents").Visible = xlVeryHidden


Sheets("Front Sheet").Select
    Range("A17:S17").Select
        Selection.ClearContents
           
    
Open1.Show


 Range("A17").Select
    
Application.ScreenUpdating = True
       
End Sub

Re: Clearing Contents Of Cells

Hi,

I broke the code down into two lines so I could see at which point it was breaking down as having the line below it still didn't work, Sorry new to VBA programming

range("A17:S17").CearContents