Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub siirra()
  2.     If Selection.Columns.Count() = 1 Then
  3.         For Each cell In Selection
  4.             If Len(cell.Value) > 0 Then
  5.                 If IsNumeric(cell.Value) = True Then
  6.                     If Int(cell.Value) = cell.Value And cell.Value > 1 Then
  7.                         cell.Offset(0, 1).Cut cell.Offset(0, cell.Value)
  8.                     End If
  9.                 End If
  10.             End If
  11.         Next
  12.     End If
  13. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement