Woksheet Function "Slope" through VBA

I am having difficulty getting my VBA to run the worksheet function correctly. I have tried making all sorts of modifications with no luck. Below is an example of one of my many failed attempts. It reads fine down to the line were it calls the worksheetfunction.slope and spits out a "Run-time error '1004': Application-defined or object-defined error". I can get the function to work fine in the worksheet (Using "=SLOPE(Table1[@[-13.78]:[0.00]],1*Table1[[#Headers],[-13.78]:[0.00]]") but I need to call it through VBA and loop through the corresponding column and rows.

Please Login or Register  to view this content.

Bernie
I had the loop on j for additional code that needed to be looped column by column. I see what you are saying that it is not needed for the slope or linest function. I had both ranges the same until I got the script to run correctly, then I would modify appropriately.

MrShorty
The error populates at the line "mL = WorksheetFunction.Slope(XL, YL)". I am going to test Bernie's modifications and se if that works.

Thank you both for the prompt response.