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.
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.
Mohd Azrie
Bt Pahat, Johor, Malaysia.
str1 = FC.Column
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Thank you John.....
Mohd Azrie
Bt Pahat, Johor, Malaysia.