Excel VBA 質問スレ Part59at TECHExcel VBA 質問スレ Part59
- 暇つぶし2ch147:デフォルトの名無しさん 19/02/15 01:43:51.10 6R3QhjK00.net もっとシンプルなのができた Function kanacaps(s1) As String t = "アイウエオヤユヨツ" For i = 1 To Len(s1) c = Mid(s1, i, 1) If "ァ" <= c And c <= "ッ" Then Mid(s1, i) = Mid(t, A sc(c) - 166, 1) End If Next kanacaps = s1 End Function