Macros and data analysis
 

Hi. I have 60 individual worksheets each with a single column of data. I
have ranges of this data which I want to analyze individually using the
Fournier Analysis function. I have defined the ranges and assigned names to
them using the insert/name/define function. When I create a macro to
automatically run the FFT I type the defined range name in for the input
range. When I run the macro the next time, it does not recognize the name
and ives me an error "input range must be a contiguous refernce" Any help
would be great

Thanks

Macros and data analysis
 

Hi Dtcb1979,

Try posting the problematic code.




---
Regards.
Norman


"dtcb1979" wrote in message
...
Hi. I have 60 individual worksheets each with a single column of data. I
have ranges of this data which I want to analyze individually using the
Fournier Analysis function. I have defined the ranges and assigned names
to
them using the insert/name/define function. When I create a macro to
automatically run the FFT I type the defined range name in for the input
range. When I run the macro the next time, it does not recognize the name
and ives me an error "input range must be a contiguous refernce" Any help
would be great

Thanks