Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dana:
Thank you for your insights - I applied your suggestions and the code now works!! I am now aware of the Index functionality - thanks again Dana DeLouis wrote: However, I cannot access the columns correctly... Hi. One way is via Index ... Sub Demo() Dim M As Variant Dim Slp As Double Dim C As Long M = [A1:C10].Value With WorksheetFunction For C = 1 To 2 Slp = .Slope(.Index(M, 0, 3), .Index(M, 0, C)) Debug.Print Slp Next C End With End Sub Hello all: [quoted text clipped - 16 lines] Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using slope function with non contiguous cells | Excel Worksheet Functions | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
Anomolous behaviour of slope function. | Excel Worksheet Functions | |||
Creating a matrix from columns | Excel Discussion (Misc queries) | |||
how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) |