Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
How to use Tools, Data Analysis, Regression in Macros | Excel Programming | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |