View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pcor[_4_] pcor[_4_] is offline
external usenet poster
 
Posts: 5
Default Macro to add up values in COMMENTs

Hi
I did receive an very nice macro to carryout a search of ALL comments
on a worksheet. What I really wanted was to have a macro that would
provide a total for an active cell.
IE
If I put my cursor on a12, and A12 contains a comment such as:
apples=12
oranges=23
The macro would place the value of 35(12+23) in that cell.
Thanks in advance