Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adressing
Hi,
I have a small problem with the address in formula. Bellow there is an example from my formula, where the name "5 Cities" is the name of sheet. G:\report\[Report.xls]5 Cities'!$D$25:$O$250 I would like to put into the formula the adress of cell where is the name "5 Cities". It will be easer next to change the name in a cell then the whole formula. Best regards, Jacek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adressing
Hi Jacek
Use INDIRECT For example if name of sheet is in E1: =INDIRECT("G:\report\[Report.xls]" & E1 &"'!$D$25:$O$250") HTH Cordially Pascal "Jacek" a écrit dans le message de ... Hi, I have a small problem with the address in formula. Bellow there is an example from my formula, where the name "5 Cities" is the name of sheet. G:\report\[Report.xls]5 Cities'!$D$25:$O$250 I would like to put into the formula the adress of cell where is the name "5 Cities". It will be easer next to change the name in a cell then the whole formula. Best regards, Jacek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|