Solved: cell comment: remove text? [Archive]

View Full Version : Solved: cell comment: remove text?

Ago

11-23-2008, 03:42 AM

how would i write the code to remove the text in a cell comment?

i have tried these,
Range("G13").Comment.Text Text:=""
Range("G13").Comment.Text Text:=vbnullstring

i also tried to get the overwrite working but i get a error.
can someone please help me?

Ago

11-23-2008, 04:43 AM

lol. so simple.....
Range("G13").Comment.Text Text:=" "
worked.