Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a small range of cells to delete
This is a portion of code where I am using a listbox selection to find a
person in a list. The last line here is where I keep getting stuck. After I find the person and move to the right, I want to select the cell I am on plus two cells to the right so I can delete them. I've looked up as much as I can in help and examples here but nothing seems to work for me. Can anyone assist? Private Sub CommandButton3_Click() Dim Remove As Object 'Remove on Employee Training Sheet Set Remove = Worksheets("Keys").Range("L19") If Remove < "" Then Range("L19").Select Selection.Copy Range("B3").Select Cells.Find(What:=Remove, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Else MsgBox ("No one is selected") End If ActiveCell.Offset(0, -1).Select Range(ActiveCell.Offset(0, 3)).Select -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200802/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a small range of cells to delete
hi
Range(ActiveCell, ActiveCell.Offset(0, 2)).Select Selection.Delete but if you want to delete, rolled it up to one line. no select needed... Range(ActiveCell, ActiveCell.Offset(0, 2)).Delete shift:=xlUp regards FSt1 "Carrie_Loos via OfficeKB.com" wrote: This is a portion of code where I am using a listbox selection to find a person in a list. The last line here is where I keep getting stuck. After I find the person and move to the right, I want to select the cell I am on plus two cells to the right so I can delete them. I've looked up as much as I can in help and examples here but nothing seems to work for me. Can anyone assist? Private Sub CommandButton3_Click() Dim Remove As Object 'Remove on Employee Training Sheet Set Remove = Worksheets("Keys").Range("L19") If Remove < "" Then Range("L19").Select Selection.Copy Range("B3").Select Cells.Find(What:=Remove, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Else MsgBox ("No one is selected") End If ActiveCell.Offset(0, -1).Select Range(ActiveCell.Offset(0, 3)).Select -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200802/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a small range of cells to delete
Gosh - I knew it was just that easy. I guess I don't get the syntax of the
"double" ActiveCell. Apparently you have to reference the cell you are on then plus more cells? Thanks so much. FSt1 wrote: hi Range(ActiveCell, ActiveCell.Offset(0, 2)).Select Selection.Delete but if you want to delete, rolled it up to one line. no select needed... Range(ActiveCell, ActiveCell.Offset(0, 2)).Delete shift:=xlUp regards FSt1 This is a portion of code where I am using a listbox selection to find a person in a list. The last line here is where I keep getting stuck. After I [quoted text clipped - 22 lines] ActiveCell.Offset(0, -1).Select Range(ActiveCell.Offset(0, 3)).Select -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200802/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a small range of cells to delete
"Carrie_Loos via OfficeKB.com" wrote: Gosh - I knew it was just that easy. I guess I don't get the syntax of the "double" ActiveCell. Apparently you have to reference the cell you are on then plus more cells? Thanks so much. FSt1 wrote: hi Range(ActiveCell, ActiveCell.Offset(0, 2)).Select Selection.Delete but if you want to delete, rolled it up to one line. no select needed... Range(ActiveCell, ActiveCell.Offset(0, 2)).Delete shift:=xlUp regards FSt1 This is a portion of code where I am using a listbox selection to find a person in a list. The last line here is where I keep getting stuck. After I [quoted text clipped - 22 lines] ActiveCell.Offset(0, -1).Select Range(ActiveCell.Offset(0, 3)).Select -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200802/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a range of cells, how to ? | Excel Programming | |||
Selecting a range of cells , how to ? | Excel Programming | |||
Selecting a range of cells, how to ? | Excel Worksheet Functions | |||
Delete cells without selecting? | Excel Programming | |||
Selecting a Range of cells in VBA | Excel Programming |