lior03
11-27-2005, 11:56 AM
hello
i am trying to find all cells in a workbook that contain
a comment in order to recalculate and change comments if necessary.
i have a macro that show formula in cell as a comment-commentalony
my macro is:
Sub ela()
Dim cell As Range
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If cell.Comment.Visible = True Then
commentalony
End If
Next
End Sub
commentalony will look into the cell
and put a new comment if necessary
before i close the workbook.
my question- how do i make excel loop through all
sheets and find all cell that contain a comment
thanks
i am trying to find all cells in a workbook that contain
a comment in order to recalculate and change comments if necessary.
i have a macro that show formula in cell as a comment-commentalony
my macro is:
Sub ela()
Dim cell As Range
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If cell.Comment.Visible = True Then
commentalony
End If
Next
End Sub
commentalony will look into the cell
and put a new comment if necessary
before i close the workbook.
my question- how do i make excel loop through all
sheets and find all cell that contain a comment
thanks