Google Mobile Ads

Wednesday, September 19, 2012

Excel VBA: Kolon Numarasından Kolon Harfini Öğrenmek


Function GetColumnLetter(ColumnNumber As Integer) As String
    GetColumnLetter= Left(Cells(1, ColumnNumber).Address(1, 0), InStr(1, Cells(1, ColumnNumber).Address(1, 0), "$") - 1)
End Function

No comments:

Post a Comment

LinkWithin

Related Posts Plugin for WordPress, Blogger...