| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to replace column letter in refferences with a function using the old column letter?
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)? |
|
#2
|
|||
|
|||
|
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)? |
|
#3
|
|||
|
|||
|
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)? |
|
#4
|
|||
|
|||
|
=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)? |
|
#5
|
|||
|
|||
|
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)? |
|
#6
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Hybrid Mode
