mattrix
09-24-2019, 11:29 PM
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,
Function abb()
ActiveSheet.Cells(3,1).value = 122333
abb = 'any thing'
End Function
In cell A1, I set =abb() and hit enter. I get #VALUE in A1 but nothing happen at A3.
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.
This was doable in previous versions but appears to have been blocked in Excel 2007.
A simple example is,
Function abb()
ActiveSheet.Cells(3,1).value = 122333
abb = 'any thing'
End Function
In cell A1, I set =abb() and hit enter. I get #VALUE in A1 but nothing happen at A3.
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.