Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA- Trend Function in Macro Problem
Help! I am trying to use the Excel trend function in a macro that I a
writing. I need to place the trend data into an array within my macro I keep getting two error messages. One saying that there is a typ mismatch when trying to subtract phase20 from phasetrend. And the othe saying that the trend data can not be assigned to an array. All of th types within the macro are variant. By the way, data is being importe into the macro. Phase20 is a subset of the imported data. Sample of code: phasetrend = Application.WorksheetFunction.trend(phase20) dflp = phase20 - phasetrend Any help would be greatly appreciated -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem creating a logarithmic trend line | Charts and Charting in Excel | |||
Trend Function | Excel Worksheet Functions | |||
constraints for the trend function | Excel Discussion (Misc queries) | |||
Help with TREND function | Excel Worksheet Functions | |||
Trend function in VB | Excel Programming |