Hello there. It's been awhile since I programmed in VBA, but as my job at the University has me working with some pretty big spreadsheets I am heading into VB to make my own UDF. Here is what I have so far:

Function NewLook(j As Integer, k As Integer)
'Initialize the Array
Dim aSize As Integer
aSize = 4200 - j
Dim bSize As Integer
bSize = k - 5
Dim a(4200) As Double...