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

Range("A1").Select
Selection.Clear

N10 :)

"Ricky" wrote in message
...
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.760 / Virus Database: 509 - Release Date: 10/09/2004

Hi,
Try cells(2,2).clear

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


-----Original Message-----
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
.

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.

Ricky wrote:

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

--

Dave Peterson

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.