Thread
:
Avoid volatile Indirect problem
View Single Post
#
3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
teepee[_2_]
external usenet poster
Posts: 10
Avoid volatile Indirect problem
interesting idea - shall try
"Don Guillett" wrote in message
...
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
"teepee" wrote in message
...
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
Reply With Quote
teepee[_2_]
View Public Profile
Find all posts by teepee[_2_]