P Pete Oct 6, 2007 #1 is there a better way to clear the contents of an entire column other then Range("a1:a65536").ClearContents ?
is there a better way to clear the contents of an entire column other then Range("a1:a65536").ClearContents ?
R Ron Rosenfeld Oct 6, 2007 #3 is there a better way to clear the contents of an entire column other then Range("a1:a65536").ClearContents ? Click to expand... 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
is there a better way to clear the contents of an entire column other then Range("a1:a65536").ClearContents ? Click to expand... 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
G G56 Oct 6, 2007 #4 is there a better way to clear the contents of an entire column other then Range("a1:a65536").ClearContents ? Click to expand... 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
is there a better way to clear the contents of an entire column other then Range("a1:a65536").ClearContents ? Click to expand... 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
J JE McGimpsey Oct 6, 2007 #5 Ron Rosenfeld said: 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. Click to expand... As should Columns(1).ClearContents
Ron Rosenfeld said: 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. Click to expand... As should Columns(1).ClearContents
