H hal Aug 8, 2003 #1 Other than a tedious looping construct, how can you quickly clear a large block of cells? TIA
R Ron de Bruin Aug 8, 2003 #2 Selection.Clear Selection.ClearContents Range("A1:A100").Clear Range("A1:A100").ClearContents Clearcontents will only clear the value in it Clear also the formatting
Selection.Clear Selection.ClearContents Range("A1:A100").Clear Range("A1:A100").ClearContents Clearcontents will only clear the value in it Clear also the formatting
C Chip Pearson Aug 8, 2003 #3 Hal, Try something like Range("A1:Z10000").Clear Or do you have something else in mind? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
Hal, Try something like Range("A1:Z10000").Clear Or do you have something else in mind? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
