Sheet1.Cells.ClearContents Not Clearing Everything

[ransomedbyfire]

I have been using Sheet1.Cells.Clearcontents to clear a sheet; but I've noticed that when I do an SQL query via VBA and use this code, it doesn't always clear all cells. So then, when I try to replace the old imported table with a new one, I get a message about not overlapping tables.

Can someone give me a better way to make sure ALL cells in a sheet are cleared?

Thanks!

 

[AlphaFrog]

Try this...

Sheet1.Cells.Clear

 

[ransomedbyfire]

AlphaFrog, thanks for the reply; but I'm thinking that the issue is mainly with what Excel considers "Cells" to be. Is there another way to tell Excel to do something to every cell in a sheet?

 

[rs2k]

What about,

Sub clearcells()
Sheet1.Cells.Delete
End Sub