| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selective clearence
Sub qwerrty()
Range("A1").ClearContents End Sub -- Gary''s Student - gsnu200909 "Gotroots" wrote: Each cell in the range has data validation - Imput Message How do I avoid this being deleted also. Range("C5:D11,G5:G11").Select Selection.Clear Thank you if you can help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selective on Name | Excel Discussion (Misc queries) | |||
| selective protection | New Users to Excel | |||
| Selective calculation | Excel Worksheet Functions | |||
| Selective Deleting | Excel Programming | |||
| Selective Viewing | Excel Programming | |||
Threaded Mode
