Difference between .clear and .delete

[mahmed1]

Hi,

what is the difference between cells.delete and cells.clear?

Are they the same thing or is there a difference?

 

[VoG]

.Delete deletes the cells.

.Clear deletes the contents and formatting.

.ClearContents deletes just the contents.

 

[mahmed1]

.Delete deletes the cells.

.Clear deletes the contents and formatting.

.ClearContents deletes just the contents.

Thank You

Am i right in saying Contents is values and formatting is any formats including Conditonal formatting?

 

[VoG]

Yes, correct.

 

[sudric]

Was wondering: which is faster - processing time wise? .clear or .delete?

 

[Jonmo1]

Clear is faster..

FYI, another 'Big' Difference between clear and delete...

Delete actually removes the cell, and the cells below actually move up to take it's place.
Clear doesn't remove the cell, the cell below stays in it's place.