Passing a variable range into fourier transform

Hello everyone,

I'm trying to figure out how to pass a range variable that I request from a user in a message box into the fourier range selection but can't seem to figure it out. Here is a working version of that VBA code with the range selected manually within the application itself (the code was generated by recording a macro while doing it).

Please Login or Register  to view this content.

So this obviously works, however, when I remove the manually inserted range and replace it with a variable I assigned to a range in the sheet it either says syntax error or expected function. Here is one of about a half dozen attempts at using the right syntax to assign a variable range.

Please Login or Register  to view this content.

The variables rngCatCells and rngOutCells have each been assigned a range value defined by the user. How should this syntax look so excel recognizes these variables as the cells to perform the fourier transform on and the cells to place the produced values into?

Thank you for any help you can provide

Welcome to the forum!

If you can attach a simple example file with some test data, it would be easier to help. Include the one with the named ranges added or how you are setting those.

To attach a file, click the Go Advanced button in bottom right of a replay, click the paperclip icon in the toolbar, and then browse and select the file to Upload.