Prev: activate, window activate?
Next: creating macro to seperate lines
From: pls123 on 18 Feb 2010 12:40
hi all !! i need a function like this next one ...

='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$999

....but with A16 value instead of 999...
can anybody help..
tx
paolo
From: tompl on 18 Feb 2010 15:40
Try this:

=INDIRECT(“'[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$” & A1)

Tom


"pls123" wrote:

> hi all !! i need a function like this next one ...
>
> ='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$999
>
> ...but with A16 value instead of 999...
> can anybody help..
> tx
> paolo
From: tompl on 18 Feb 2010 15:42
Try this:

=INDIRECT(“'[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$” & A16)

Tom


"pls123" wrote:

> hi all !! i need a function like this next one ...
>
> ='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$999
>
> ...but with A16 value instead of 999...
> can anybody help..
> tx
> paolo
From: pls123 on 18 Feb 2010 15:55

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

paolo




"tompl" wrote:

> Try this:
>
> =INDIRECT(“'[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$” & A1)
>
> Tom
>
>
> "pls123" wrote:
>
> > hi all !! i need a function like this next one ...
> >
> > ='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$999
> >
> > ...but with A16 value instead of 999...
> > can anybody help..
> > tx
> > paolo
 | 
Pages: 1
Prev: activate, window activate?
Next: creating macro to seperate lines