Clear all cells (cells.clear)

[lezawang]

Hi
to clear all cells I can write this code

Sub clearall()
    Cells.Clear
End Sub

I used object browser and found that cells is a property of 3 objects

Application.Cells
Range.Cells
WorkSheet.Cells

So my question, which one I am using when I say Cells. Clear?

Thank you

 

[RoryA]

In a worksheet code module, it's effectively Me.Cells, which is Worksheet.Cells. If the code is in a different module, it's Application.Cells since you didn't specify a sheet (which should be the same as Activesheet.Cells).