| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Selection.Delete Shift:=xlToLeft
I have a table and in the column D there are values that could either
be "A" or "T". What I would like is a macro that could go though each value in column D and if The value is "A" Then for that row would shift the data in the row left... Range("G4:H4").Select ' Not limited to row 4 but to that specific row Selection.Delete Shift:=xlToLeft Else If The value is "T" Then for that row would shift the data in the row left... Range("H4:J4").Select ' Not limited to row 4 but to that specific row Selection.Delete Shift:=xlToLeft Is this doable? Brenda...Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selection By Shift & Arrow In VBA | Excel Discussion (Misc queries) | |||
| Excel 2007 Shift-Page Down Selection | Setting up and Configuration of Excel | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Selection.End(xlToLeft).Select | Excel Programming | |||
| Shift+Arrow does not expand selection | Excel Discussion (Misc queries) | |||
Threaded Mode
