I have a spreadsheet that needs to get a piece of data from a large worksheet on another disk. I am using vlookup to find that value. In the Vlookup I refer to the other file in the second argument as
's:\[&$B$28&]sheet1'!$A$2:$U$16000 Where B28 contains a string with the filename holding the data.
This works but every time I make a change when Vlookup is executing it pops up a dialogue box asking me to update the values for $b$28. It shows the files in the right directory but asks me to click on the proper file containing the data. Any way to avoid this? It seems to me I am giving excell all the informaiton it needs to find the file.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…