I have a cell formula in my spreadsheet

=INDIRECT("'http://www.domain.com/" &$B$2&"/[results.xls]results'!$e2")

&$B$2& rfefers to the second part of a URL which changes as B21 changes its
value

The spreadsheet functions perfectly except that it goes incredibly slowly
because INDIRECT is volatile and there are 120,000 occurences of this
formula or a variation on the same.

Anyone know a way around this or an alternative to INDIRECT that does the
same thing?

Many thanks

tp

how about a nice looping macro
for i=1 to whatever number
cells(i,2)="aaaaaaaaaa"&cells(i,1)&"bbbbbbbbbb"
next

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"teepee" <(E-Mail Removed)> wrote in message
news:46432b51$(E-Mail Removed)...
>I have a cell formula in my spreadsheet
>
> =INDIRECT("'http://www.domain.com/" &$B$2&"/[results.xls]results'!$e2")
>
> &$B$2& rfefers to the second part of a URL which changes as B21 changes
> its
> value
>
> The spreadsheet functions perfectly except that it goes incredibly slowly
> because INDIRECT is volatile and there are 120,000 occurences of this
> formula or a variation on the same.
>
> Anyone know a way around this or an alternative to INDIRECT that does the
> same thing?
>
> Many thanks
>
> tp
>
>
>
>

interesting idea - shall try

"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
how about a nice looping macro
for i=1 to whatever number
cells(i,2)="aaaaaaaaaa"&cells(i,1)&"bbbbbbbbbb"
next

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"teepee" <(E-Mail Removed)> wrote in message
news:46432b51$(E-Mail Removed)...
>I have a cell formula in my spreadsheet
>
> =INDIRECT("'http://www.domain.com/" &$B$2&"/[results.xls]results'!$e2")
>
> &$B$2& rfefers to the second part of a URL which changes as B21 changes
> its
> value
>
> The spreadsheet functions perfectly except that it goes incredibly slowly
> because INDIRECT is volatile and there are 120,000 occurences of this
> formula or a variation on the same.
>
> Anyone know a way around this or an alternative to INDIRECT that does the
> same thing?
>
> Many thanks
>
> tp
>
>
>
>