Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With recent help from Bob Alhat and Gary"s Student the macro below works
until there is a cell without a comment. I need an "If" statement which will skip a "no comment" cell. Please! Camlad Sub RemoveComments() Count = 13 LastRow = Cells(Rows.Count, "A").End(xlUp).Row While LastRow Count If Cells(Count, 3).........(what do I put here for "has a comment").............Then CommentText = Cells(Count, 3).Comment.Text Cells(Count, 2) = CommentText Cells(Count, 3).Comment.Delete End If Count = Count + 1 Wend End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting code comments from modules | Excel Programming | |||
deleting comments | Excel Discussion (Misc queries) | |||
Add comments without deleting. | Excel Discussion (Misc queries) | |||
Deleting comments | Excel Programming | |||
Deleting comments | Excel Programming |