ExcelBanter - reference inside worksheet function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - reference inside worksheet function (https://www.excelbanter.com/excel-programming/439699-reference-inside-worksheet-function.html)

pls123

reference inside worksheet function

hi all !! i need a function like this next one ...

]Sheet1'!$D$999

....but with A16 value instead of 999...
can anybody help..
tx
paolo

TomPl

reference inside worksheet function

Try this:

]Sheet1'!$D$€ & A1)

Tom

"pls123" wrote:

hi all !! i need a function like this next one ...

]Sheet1'!$D$999

...but with A16 value instead of 999...
can anybody help..
tx
paolo

TomPl

reference inside worksheet function

Try this:

]Sheet1'!$D$€ & A16)

Tom

"pls123" wrote:

hi all !! i need a function like this next one ...

]Sheet1'!$D$999

...but with A16 value instead of 999...
can anybody help..
tx
paolo

pls123

reference inside worksheet function

i think you told it !!
thank you tompl i was losing a lot of afternoon !

paolo

"tompl" wrote:

Try this:

]Sheet1'!$D$€ & A1)

Tom

"pls123" wrote:

hi all !! i need a function like this next one ...

]Sheet1'!$D$999

...but with A16 value instead of 999...
can anybody help..
tx
paolo

All times are GMT +1. The time now is 09:37 PM.