Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Meenachi Suppiah   on Dec 09 In MS Office Category.

help with making macro with user input


  
Question Answered By: Harriet Ward   on Dec 09

Try:
Sub MeanSDSEM()
x = InputBox("Enter number  of samples")
ActiveCell.FormulaR1C1 = "=AVERAGE(RC[-1]:R[" & x - 1 & "]C[-1])"
ActiveCell.Offset(0, 1).Select
ActiveCell.FormulaR1C1 = "=STDEV(RC[-2]:R[" & x - 1 & "]C[-2])"
ActiveCell.Offset(0, 1).Select
ActiveCell.FormulaR1C1 = "=RC[-1]/SQRT(" & x & ")"
ActiveCell.Offset(1, 0).Select
End Sub

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on help with making macro with user input Or get search suggestion and latest updates.


Tagged: