Translate Column Reference to Column Index
Here is a VBA function that converts a column reference to a column index.
Function ColRef2ColNo(ColRef As String) As Integer
ColRef2ColNo = 0
On Error Resume Next
ColRef2ColNo = Range(ColRef & "1").Column
End Function
The URI to TrackBack this entry is: http://jdev.blogsome.com/2008/11/03/translate-column-reference-to-column-index/trackback/
No comments yet.
RSS feed for comments on this post.
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>
