B
bbcdancer
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.
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.