Thread: better way clearcontents column?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default better way clearcontents column?
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
Reply With QuoteReply With Quote