AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,940
- Office Version
- 2019
- 2016
- Platform
- Windows
VBA Code:
Set rng = rng.SpecialCells(xlCellTypeComments)
For Each cl In rng
cl.comment.text = Replace(cl.comment.text, Chr$(45), Chr$(150))
next
Is it possible to edit Comment text (keeping any formatting) or must the whole
comment be removed and replaced?