Advertisement
Guest User

Untitled

a guest
Aug 25th, 2013
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. '
  2. 'A列のを文字列反転してC列へ
  3. '
  4. 'C列をキーにして並べ変えたらA列がドメイン順にならぶことに
  5. '
  6. Sub jijiji()
  7. nEnd = Cells.SpecialCells(xlCellTypeLastCell).Row
  8.  
  9. For i = 1 To nEnd
  10. Cells(i, 1) = Trim(Cells(i, 1))
  11. Cells(i, 3) = RevStr(Cells(i, 1))
  12. Next
  13.  
  14. End Sub
  15.  
  16.  
  17.  
  18. Public Function RevStr(s) As String
  19.  
  20. Dim a As String
  21. Dim i As Long
  22.  
  23. '** 文字列反転
  24. For i = Len(s) To 1 Step -1
  25. a = a & Mid(s, i, 1)
  26. Next
  27. RevStr = a
  28.  
  29. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement