I'd record a macro when I selected the cell and added the comment.

Then just rerun this macro for the other worksheets.

dh wrote:

i would like to make a comment on one worksheet (entire workbook is same
sheet format) and paste it to rest of workbook sheets in same cell..thanks in
advance

--

Dave Peterson