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 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 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 ,
Ron Rosenfeld 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