View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BLenz BLenz is offline
external usenet poster
 
Posts: 1
Default 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