I have a number of cells that have comments such as :
apples=25
organes=60
pears=12

I would select any cells that contains a comment and have the macro
count up the NUMBERS in the comment and show the total in that cell
Thanks