Macro Info...

[B_2]

Is it possible for a macro to delete comments within specified cells?

such as A2 & B4


Regards

 

[Mudface]

Yes, for example: -

Range("A2,B4").ClearComments

Best way to find out about things like this is just to record yourself doing them and then edit the code to suit.

 

[B_2]

Sub Clear_Contents()
Range("A2,B4").ClearContents
End Sub

did the trick..thx for the reply Mudface

 

[Richie(UK)]

Hi B_2,

Just to clarify, the code that Mudface provided will clear any comments in a cell (ie comments added with 'Insert Comment' and leaving the telltale red triangle in top-right corner of the cell), which is what you asked for.

The code example that you provided clears the contents of the cell (ie normal data entry into a cell).

These are two different things, make sure you are using the method that will give the desired result :wink:.

_________________<font color="blue"> «««<font color="red">¤<font color="blue"><font size=+1>Richie</font><font color="red">¤<font color="blue"> »»»</font>

</gif>
This message was edited by Richie(UK) on 2002-10-20 15:53

 

[Jack in the UK]

Hi

Some what confused but try this
Highlight you cell and run this code from command buttion



Activecells.select
Selection.ClearComments

[A1].select

this will do as you ask,mif used as i have explained

Jack

 

[Jack in the UK]

Just for fun if you want to remove ALL coments this might help you

Sub Jack_ClearComments()
For Each Jack In ActiveSheet.Comments
Jack.Delete
Next
End Sub

 

[B_2]

thx for the reply guys