Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selective clearence
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selective clearence
Try
ActiveSheet.Range("C5:D11,G5:G11").ClearContents -- HTH, Barb Reinhardt "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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selective clearence
Use Clearcontents instead of Clear. Clear will remove formating while clearcontents will only remove text/numbers. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=167403 Microsoft Office Help |
#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. |
Reply |
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 |