How do I get an Excel function to run with a Macro

[RFeniuk]

I am trying to set up a button in excel that will automatically run a T-Test on a given set of data. How do I write the code for this in VBA. I am using Excel 97.

I have my data in 2 columns which are named "Operator1" & "Operator2"

I want the T-Test results to go to Cell A67

Can some one help me?

 

[PHV]

Have you tried the macro recorder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gh61]

Recording a macro gives this:

Application.Run "ATPVBAEN.XLA!Pttestm", , , ActiveSheet.Range("$M$14"), _
False, 0.05

It recorded my output range but not my input ranges.

You may need to search MSDN to find out the correct arguments.


HTH

Graeme