S Shawshank Jan 13, 2004 #1 I want to clear the content of a whole worksheet using VBA. Does anyone know how to do it? Thanks!
C Chip Pearson Jan 13, 2004 #3 Try something like Worksheets("Sheet1").Cells.Clear ' or ClearContents -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Try something like Worksheets("Sheet1").Cells.Clear ' or ClearContents -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
B Bob Phillips Jan 13, 2004 #4 ActiveSheet.Cells.ClearContents -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
ActiveSheet.Cells.ClearContents -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
