|
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)? |
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)? |
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)? |
=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)? |
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)? |
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)? |
Thanks.
I have to make a 2004 year calculation using 2004 year table in the same way a 2003 year calculation which used 2003 year table was made. I copied formulas from 2003 version table to 2004 version table. The 2004 version table has different columns order therefore column letters in the formulas are incorrect. I want to change the column letters to correct ones according to 2003 and 2004 column lables located in a top row in the tables. I have to use columns with the same lables as in 2003 year in formulas. How to change the column letters to correct ones in all cells automatically? I do not need to change row numbers because they are correct. "Bob Phillips" сообщил/сообщила в новостях следующее: ... 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)? |
| All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com