I use a simple UDF
'-----------------------------------------------------------------
Function ColumnLetter(Col As Long)
'-----------------------------------------------------------------
Dim sColumn As String
sColumn = Split(Columns(Col).Address(, False), ":")(1)
ColumnLetter = sColumn
End Function
--
HTH
Bob Phillips
"Dmitry Kopnichev" wrote in message
...
Thanks!
How to convert a column number to a corresponding column label, letter?
"Bob Phillips" сообщил/сообщила в
новостях следующее: ...
=INDIRECT(A1&ROW())
--
HTH
Bob Phillips
"Dmitry Kopnichev" wrote in message
...
Thanks for your reply.
How to change =C1 (any reference) to =INDIRECT(A1&1(the same row
number)
automatically?
"Bob Phillips" сообщил/сообщила в
новостях следующее: ...
I think you mean
=INDIRECT(A1&7)
where A1 holds the letter in this instance.
--
HTH
Bob Phillips
"Dmitry Kopnichev" wrote in message
...
Hello
How to replace column letter(s) (or column numbers) in refferences
with
a
result of a function using the old column letter(s) (or column
numbers)?
|