PDA

View Full Version : Solved: Identify column number from address



m.azrie
12-05-2006, 09:58 PM
Hello,
Could someone help me to find out how to identify column number from address.

Set FC = Rows(1).Find("NAME")
If Not FC Is Nothing Then
Str1 = FC.Address
( Q: How to identify Column from Str1? )
End If

Thanks.

johnske
12-05-2006, 10:10 PM
str1 = FC.Column

m.azrie
12-05-2006, 10:29 PM
Thank you John.....