My problem is I have a long column of times and a sparse column of values at those times. I want to fill another column with values interpolated between those in the sparse array.
This was doable in previous versions but appears to have been blocked in Excel 2007.
A simple example is,
In cell A1, I set =abb() and hit enter. I get #VALUE in A1 but nothing happen at A3.Function abb() ActiveSheet.Cells(3,1).value = 122333 abb = 'any thing' End Function
A second question, for my initial problem, I want to create a range for the results that is the column of ActiveCell, ie if the function is in E1, the created range is E:E. How do I do this?
Thanks for your help.