"method range of object _worksheet failed" Error

[sudeepsodani]

Hi,

I am using excel 2007 and am new to using vba code. Am trying to generate a code to delete cells in a range (around 300k rows). Here is the clearcontents option I am using. I am however, getting the error "method range of object _worksheet failed". Is this because the range is too much? Is there a better function I could use? Please advise. Thanks.

Sheet3.Range("A2:F300000").ClearContents.

[patel]

Sheets("Sheet3").Range("A2:F300000").ClearContents

[Simon Lloyd]

Or even betterApplication.Screenupdating = False
Sheets("Sheet3").Range("A2:F" & Sheets("Sheet3").Range("F" & Rows.Count).End(xlUp).Row).ClearContents
Application.Screenupdating = True