Help a Newbie with Worksheet.Application Functions in VBA?
Help a Newbie with Worksheet.Application Functions in VBA?
(OP)
Hi Group,
I have a monster VBA program written, and for the first time ever I want to use a worksheet function (LinEst). I've searched the world, but I can't find the answer to "Run Time Error 424 - Object Required" that I get.
A simple example is attached. Can anyone take the time to point me in the right direction?
I have a monster VBA program written, and for the first time ever I want to use a worksheet function (LinEst). I've searched the world, but I can't find the answer to "Run Time Error 424 - Object Required" that I get.
A simple example is attached. Can anyone take the time to point me in the right direction?
Best to you,
Goober Dave
Haven't see the forum policies? Do so now: Forum Policies





RE: Help a Newbie with Worksheet.Application Functions in VBA?
In order to use the LINEST function you'd need to have something like the following (at a minimum)
answer = Appplication.WorksheetFunction.LinEst("B2:B21","C2:C21")
RE: Help a Newbie with Worksheet.Application Functions in VBA?
Best to you,
Goober Dave
Haven't see the forum policies? Do so now: Forum Policies