Zero value in range

rsynec · Sep 9th 2005

I have a range named "PKI2" with numeric values in each cell. I would like to zero out the values using a macro. What code would I use?

**norie** · Sep 9th 2005

Re: Zero value in range

What do you mean by zero out?

Do you want to put a zero in each cell or clear the contents?

Code

Range("PK12")=0

Code

Range("PK12").ClearContents

rsynec · Sep 9th 2005

Re: Zero value in range

Thank you, the placement of the zero is what I wanted to do. It's the simple things that I have a diffecult time comprehending.

Rich

Participate now!