| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear contents of worksheet before populating
Hi everyone, I need a piece of code that will allow me to
clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
Tom,
Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
Of course, the first line should be
ActiveSheet.Cells.ClearContents -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... Tom, Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
Hi Chip, In the VB application I'm accessing four separate
worksheets at different times and writing to two others at different times. I want to clear one certain worksheet at the beginning of the code. Is there a way to statically tell the VB code which worksheet to clear? Thanks -----Original Message----- Tom, Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
Tom,
Sure you can. Instead of ActiveSheet, just specify the appropriate sheet. For example, Worksheets("Sheet2").Cells.ClearContents -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi Chip, In the VB application I'm accessing four separate worksheets at different times and writing to two others at different times. I want to clear one certain worksheet at the beginning of the code. Is there a way to statically tell the VB code which worksheet to clear? Thanks -----Original Message----- Tom, Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
Thanks Chip, as usual your suggestions work.
You should be getting paid for doing this. -----Original Message----- Tom, Sure you can. Instead of ActiveSheet, just specify the appropriate sheet. For example, Worksheets("Sheet2").Cells.ClearContents -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi Chip, In the VB application I'm accessing four separate worksheets at different times and writing to two others at different times. I want to clear one certain worksheet at the beginning of the code. Is there a way to statically tell the VB code which worksheet to clear? Thanks -----Original Message----- Tom, Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks . . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
Sheets("Sheet3").Cells.ClearContents
Instead of Activesheet use a sheet name. The sheet don't have to be active Tom -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tom" wrote in message ... Hi Chip, In the VB application I'm accessing four separate worksheets at different times and writing to two others at different times. I want to clear one certain worksheet at the beginning of the code. Is there a way to statically tell the VB code which worksheet to clear? Thanks -----Original Message----- Tom, Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks . |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
This may be a coincidence but a coworker just asked me
almost the same question. Can I clear all cells in a worksheet EXCEPT for a specific row such as a header row? -----Original Message----- Sheets("Sheet3").Cells.ClearContents Instead of Activesheet use a sheet name. The sheet don't have to be active Tom -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tom" wrote in message ... Hi Chip, In the VB application I'm accessing four separate worksheets at different times and writing to two others at different times. I want to clear one certain worksheet at the beginning of the code. Is there a way to statically tell the VB code which worksheet to clear? Thanks -----Original Message----- Tom, Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks . . |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear contents of worksheet before populating
Tom,
Try something like the following: With Worksheets("Sheet1") .Range(.Range("A2"), ..UsedRange.SpecialCells(xlCellTypeLastCell)).Clea rContents End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... This may be a coincidence but a coworker just asked me almost the same question. Can I clear all cells in a worksheet EXCEPT for a specific row such as a header row? -----Original Message----- Sheets("Sheet3").Cells.ClearContents Instead of Activesheet use a sheet name. The sheet don't have to be active Tom -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tom" wrote in message ... Hi Chip, In the VB application I'm accessing four separate worksheets at different times and writing to two others at different times. I want to clear one certain worksheet at the beginning of the code. Is there a way to statically tell the VB code which worksheet to clear? Thanks -----Original Message----- Tom, Try ActiveSheet.Cells.Clear ' or ActiveSheet.Cells.Clear -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi everyone, I need a piece of code that will allow me to clear the contents of an entire worksheet so I can repopulate it with fresh information. Any suggestions? Thanks . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Contents | Setting up and Configuration of Excel | |||
| Clear Contents | Excel Discussion (Misc queries) | |||
| How to copy an Excel worksheet with formulas and clear contents. | Excel Discussion (Misc queries) | |||
| weird thing about clear contents of a worksheet.... | Excel Discussion (Misc queries) | |||
| Clear Contents But Not Formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
