is there a better way to clear the contents of an entire column
other then

Range("a1:a65536").ClearContents

?

Columns("A:A").ClearContents

"Pete" wrote:

> is there a better way to clear the contents of an entire column
> other then
>
> Range("a1:a65536").ClearContents
>
> ?
>

On Sat, 06 Oct 2007 19:50:39 GMT, Pete <(E-Mail Removed)> wrote:

>is there a better way to clear the contents of an entire column
>other then
>
>Range("a1:a65536").ClearContents
>
>?

Different, but I don't know if it is "better":

Range("a1").EntireColumn.ClearContents

Maybe it is better as it should work on Excel 2007 also.
--ron

Pete <(E-Mail Removed)> wrote in news:Xns99C196B2A3BA9nsnscom@
207.115.17.102:

> is there a better way to clear the contents of an entire column
> other then
>
> Range("a1:a65536").ClearContents
>
> ?
>

Thanks Mike and Ron

Both do what I was looking for.

Plus I tried this

Columns(1).ClearContents

and it worked.

So thre are three more ways,
Range("a1").EntireColumn.ClearContents
Columns("A:A").ClearContents
Columns(1).ClearContents

In article <(E-Mail Removed)>,
Ron Rosenfeld <(E-Mail Removed)> wrote:

> Different, but I don't know if it is "better":
>
> Range("a1").EntireColumn.ClearContents
>
> Maybe it is better as it should work on Excel 2007 also.

As should

Columns(1).ClearContents