Fourier analysis with variable input

I have two pieces of code. The first one runs fine, the second one gives the run-time error '1004' Application-defined or object-define error. Could someone help me? As you can see, I am trying to sweep through columns and calculate Fourier transforms.

1st (runs well)
Application.Run "ATPVBAEN.XLAM!Fourier", Worksheets("Red").Range("$A1:A128"), _
Worksheets("Analysis - Red").Range("AV430"), False, False

2nd (run-time error)
i = 1

Application.Run "ATPVBAEN.XLAM!Fourier", Worksheets("Red").Range(Cells(1, i), Cells(128, i)), _
Worksheets("Analysis - Red").Range(Cells(430, 48 + i)), False, False

I thank you both and apologize for not posting the code in the correct fashion (using tags).

I have just tried the first suggestion and it worked! I am afraid I do not fully understand VBA so I am not sure why it worked but I am very happy.

I also looked at the second suggestion but have not tried it yet. However, looking up the error message earlier today I understood it was about not having the proper reference to the sheet so I am pretty sure it will work as well.

Thanks a lot again!