| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I select a whole range and delete the contents of the cells?
I thankyou in advance
Can someone please tell me how I select a whole range and delete the contents of the cells in that range? (in VB code) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I select a whole range and delete the contents of the cells?
Hi there,
How about this: Sub DeleteCells() 'use this to delete contents without ever selecting the cell (faster) Range("B10:C12").ClearContents 'use this to select the range first then delete the contents (if you need the range to be selected) Range("B10:B12").Select Selection.ClearContents End Sub Any use? Cheers, Foss -----Original Message----- I thankyou in advance. Can someone please tell me how I select a whole range and delete the contents of the cells in that range? (in VB code) . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I select a whole range and delete the contents of the cells?
Spot on thanks for that ----- Foss wrote: ---- Hi there How about this Sub DeleteCells( 'use this to delete contents without ever selecting the cell (faster Range("B10:C12").ClearContent 'use this to select the range first then delete the contents (if you need the range to be selected Range("B10:B12").Selec Selection.ClearContent End Su Any use Cheers Fos -----Original Message---- I thankyou in advance Can someone please tell me how I select a whole range and delete the contents of the cells in that range? (in VB code |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a range of rows to delete | Excel Worksheet Functions | |||
| Delete contents unlocked cells | Excel Discussion (Misc queries) | |||
| compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
| Delete contents of cells | Excel Worksheet Functions | |||
| How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
Linear Mode
