[RESOLVED] [VBA Excel] .ClearNotes method

[Earlien]

Hi all,

I have been looking into various methods for deleting cells or contents of cells and am a little confused by the ClearNotes method. Originally I thought it may have been legacy code and superseded by ClearComments. I did a few tests and discovered that it does indeed delete comments in a cell, but cannot see any difference between the two.

However, on the MS website, it describes this method as:

Clears notes and sound notes from all the cells in the specified range.

This doesn't sound like legacy code to me.

So my question is, apart from comments, what else does this include? What are "sound notes"?

[vbfbryce]

SoundNote Property [Excel 2003 VBA Language Reference]
Office 2003

This property should not be used. Sound notes have been removed from Microsoft Excel.

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

[Earlien]

Ok, thats kinda helpful. But I know that .ClearNotes deletes more than just these 'sound notes' (whatever they were) because I've tested it and I know it deletes comments too. Does it delete anything else? Or is comments the only other thing it deletes, and is therefore completely superseded by .ClearComments? (This is the impression I get from your reply, but would like clarification).

[Earlien]

Did some more research.

Apparently, Cell Comments were called Cell Notes in Excel 2000 and earlier. So .ClearNotes does nothing more than .ClearComments.