I had no problem selecting all sheets and all cells then
F5SpecialCommentsOK

ReviewDelete cleared all Comments on all sheets.


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 11:37:18 -0800 (PST), Bill Carlson
wrote:

Excel 2007

We are a small cpa firm, it is tax season... We frequently copy last
year's workbook to set-up the current year. I'm trying to select and
delete all cell comments as part of this set-up process.

I've tried goto special and the comments section of the Review ribbon,
but I seemed to be stumped in trying to select all cells in the
workbook that contain a comment and then to delete these comments
without cycling through the next comment for each comment on the
Review ribbon.

As always, help is much appreciated,

Bill Carlson