Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey guys
This code deletes cells but it also deletes named ranges. Is there anyway to protect my ranges where this does not happen? Dim found As Range If CheckBox4.Value Then Set found = Worksheets(1).Range("A4:Z4").Find( _ What:=ComboBox1.Value, _ After:=Worksheets(1).Range("Z4"), _ LookIn:=xlValues, _ LookAt:=xlWhole, _ MatchCase:=False) If Not found Is Nothing Then _ found.Resize(97, 1).Delete Shift:=xlToLeft End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Some 'Names' cannot be deleted by Insert|Name|Define-Delete button | Excel Worksheet Functions |