Jin's Joke Made for Excel VBA

글쓴이: 익명 사용자 / 작성시간: 일, 2005/03/27 - 12:45오후
VBA for Excel...
실무를 위해... VBA를 강요당하고 있습니다..흑.
그리우십니까?
(懐かしいですか。)
Option Explicit Sub jin_score() 'If Not IsErr(ActiveCell.Value) Then ActiveCell.Offset(0, 1).Value = JinScore(ActiveCell.Value) 'End If End Sub Private Function JinScore(s As String) As Integer Dim cnt As Integer cnt = 0 Dim ch As Integer Dim i As Integer For i = 1 To Len(s) ch = AscW(LCase(Mid(s, i, 1))) - AscW("a") + 1 If ch >= 1 And ch <= 26 Then cnt = cnt + ch End If Next i JinScore = cnt End Function
Forums:
try Convert xls to csv
try Convert xls to csv
댓글 달기