View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
rozb rozb is offline
external usenet poster
 
Posts: 10
Default Moving XL Data over By one Column (*Same Row)

ub InsertExtraBlankCell(
ActiveSheet.Range("d2:d200").Selec
rng = Selection.Rows.Coun
ActiveCell.Offset(0, 0).Selec
Application.ScreenUpdating = Fals
For i = 1 To rn
If ActiveCell.Value = "Reg:" The
Selection.Insert Shift:=xlToRigh
Els
ActiveCell.Offset(1, 0).Selec
End I
Next
Application.ScreenUpdating = Tru
End Su

We were working backwards..so we inserted instead.