S7y, I apologize; I didn't notice this before, and it's only by sheerest luck that I happened just now to glance down the list to look at old posts. I'm surprised no one else responded, but then it was just after the holidays; maybe they all missed it too.

I'm sure it's possible to have VBA do what you're talking about, but I'm not sure yet what you mean. I think (after rereading a couple times) you're saying something like this: For each cell in Sheet1!J8:J57 you want to create a column of n values in Sheet2, each value to be calculated as ROUND(x,14)/n, where n is anywhere from 96 to 125. So if n is 100 and in Sheet1!J8:J57 are the values 800, 900, 1000, 1100 and so on up to 5700, you want Sheet2 to have a series of columns (let's say H1 through BE100); in Sheet2!H1:H100 should be the value 8, in column I should be 9, in J 10 and so on.

Is this even partly right? If so, yes, it's easy to get VBA to do it. It may even be possible to do without VBA, though I'd have to think about it.