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