Avoid volatile Indirect problem

  • Thread starter Thread starter teepee
  • Start date Start date
T

teepee

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
 
interesting idea - shall try

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL VBA non-volatile INDIRECT 2
Make only active sheet Volatile? Or other solutions? 3
Indirect reference causes statistical function to throw up a #NUM! 10
Problems with using TEXT, INDIRECT and ADDRESS within an array for 10
Calculating(Processors(2)): % 1
INDIRECT(ADDRESS) inside a VLOOKUP 13
Problem using multiple criteria to get a count 1
Calculating(Processor(2)): % 8

Back
Top