| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Notation for Excel Functions in VBA
I am trying to perform calculations on data using the Excel function
SLOPE and INTERCEPT, but I am unable to find the correct notation fo the ranges that I need. I need something to the effect of: mySlope Application.WorksheetFunction.Slope(Cells(start_da ta,end_data) Cells(start_time,end_time)) start_data, end_data, start_time, end_time have been determine previously. I know that the above does NOT work, but I need something similar tha can give me the result I need. Any help/ideas are much appreciated. -Becki -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What does the ! notation mean in excel financial formulas? | Excel Worksheet Functions | |||
| Set Notation in Excel | Excel Discussion (Misc queries) | |||
| Expand IP Address range from slash notation to individual IPs... | Excel Discussion (Misc queries) | |||
| scientific notation to display 1.8 x 10-5 in Excel | New Users to Excel | |||
| Using Range with R1C1 notation in a macro | Excel Programming | |||
Threaded Mode
