How to delete a cell using VBA?

[Ricky]

Hi

I would like to know how to delete all content in a cell using VBA (not
just the value, but also Comment)

Thanks.

Ricky

 

[N10]

Range("A1").Select
Selection.Clear

N10

Hi

I would like to know how to delete all content in a cell using VBA (not
just the value, but also Comment)

Thanks.

Ricky

 

[Guest]

Hi,
Try cells(2,2).clear

This will clear cell B2 of content, format comment, etc.

 

[Dave Peterson]

And if you only want to remove the content and the comment, you could record a
macro when you do it.

You'll see the code.

 

[Peter Huang]

Hi Ricky,

If you still have any concern on this issue, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.