Modify ClearContents
I have a workbook with two worksheets, namely Archive and Data.
The following code clears all the cell in the Archive worsheet when a click event is started. As all cells are cleared, it wipes out any formulae as well! How would I have to modify the code so that it only cleared lines 1 to 500, or certain cells? Sheets("Archive").Select Sheets("Archive").Cells.Select Selection.ClearContents TIA. -- |
Modify ClearContents
I cann't help with deleting 'certain cells' unless you are specific but this
will delete rows 1 thu 500 Sub deleteme() Sheets("Archive").Select Rows("1:500").Select Selection.ClearContents End Sub "Saxman" wrote: I have a workbook with two worksheets, namely Archive and Data. The following code clears all the cell in the Archive worsheet when a click event is started. As all cells are cleared, it wipes out any formulae as well! How would I have to modify the code so that it only cleared lines 1 to 500, or certain cells? Sheets("Archive").Select Sheets("Archive").Cells.Select Selection.ClearContents TIA. -- |
Modify ClearContents
Worksheets("Archive").Range("A1:IV500").specialCel ls(xlConstants).ClearContents
-- Regards, Tom Ogilvy "Saxman" wrote: I have a workbook with two worksheets, namely Archive and Data. The following code clears all the cell in the Archive worsheet when a click event is started. As all cells are cleared, it wipes out any formulae as well! How would I have to modify the code so that it only cleared lines 1 to 500, or certain cells? Sheets("Archive").Select Sheets("Archive").Cells.Select Selection.ClearContents TIA. -- |
Modify ClearContents
Mike wrote:
I cann't help with deleting 'certain cells' unless you are specific but this will delete rows 1 thu 500 Sub deleteme() Sheets("Archive").Select Rows("1:500").Select Selection.ClearContents End Sub ' I get a RunTime error with the above Rows("1:500").Select'. -- |
Modify ClearContents
Tom Ogilvy wrote:
Worksheets("Archive").Range("A1:IV500").specialCel ls(xlConstants).ClearContents Where exactly do I paste the above in the code and what does IV signify? Thanks. -- |
Modify ClearContents
Saxman wrote:
Tom Ogilvy wrote: Worksheets("Archive").Range("A1:IV500").specialCel ls(xlConstants).ClearContents Where exactly do I paste the above in the code and what does IV signify? I got it woking now! Thanks. -- |
All times are GMT +1. The time now is 03:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com