<엑셀VBA 입문 16강> VBA로 워크시트 함수 활용하기

Sub 매크로1()
‘
‘ 매크로1 매크로
‘
‘ 바로 가기 키: Ctrl+k
‘

    Set myRange = Worksheets(“Sheet1”).Range(“A1:C10”)

    Dim result

    ‘SUM함수 사용

    result = Application.WorksheetFunction.Sum(myRange)
    MsgBox (“합계 : ” & result)

    ‘AVERAGE함수 사용 

    result = Application.WorksheetFunction.Average(myRange)
    MsgBox (“평균 : ” & result)

End Sub

AccrInt, AccrIntM, Acos, Acosh, Acot, Acoth, Aggregate, AmorDegrc, AmorLinc, And, Arabic, Asc, Asin, Asinh, Atan2, Atanh, AveDev, Average, AverageIf, AverageIfs, BahtText, Base, BesselI, BesselJ, BesselK, BesselY, Beta_Dist, Beta_Inv, BetaDist, BetaInv, Bin2Dec, Bin2Hex, Bin2Oct, Binom_Dist, Binom_Dist_Range, Binom_Inv, BinomDist, Bitand, Bitlshift, Bitor, Bitrshift, Bitxor, Ceiling, Ceiling_Math, Ceiling_Precise, ChiDist, ChiInv, ChiSq_Dist, ChiSq_Dist_RT, ChiSq_Inv, ChiSq_Inv_RT, ChiSq_Test, ChiTest, Choose, Clean, Combin, Combina, Complex, Confidence, Confidence_Norm, Confidence_T, Convert, Correl, Cosh, Cot, Coth, Count, CountA, CountBlank, CountIf, CountIfs, CoupDayBs, CoupDays, CoupDaysNc, CoupNcd, CoupNum, CoupPcd, Covar, Covariance_P, Covariance_S, CritBinom, Csc, Csch, CumIPmt, CumPrinc, DAverage, Days, Days360, Db, Dbcs, DCount, DCountA, Ddb, Dec2Bin, Dec2Hex, Dec2Oct, Decimal, Degrees, Delta, DevSq, DGet, Disc, DMax, DMin, Dollar, DollarDe, DollarFr, DProduct, DStDev, DStDevP, DSum, Duration, DVar, DVarP, EDate, Effect, EncodeURL, EoMonth, Erf, Erf_Precise, ErfC, ErfC_Precise, Even, Expon_Dist, ExponDist, F_Dist, F_Dist_RT, F_Inv, F_Inv_RT, F_Test, Fact, FactDouble, FDist, FilterXML, Find, FindB, FInv, Fisher, FisherInv, Fixed, Floor, Floor_Math, Floor_Precise, Forecast, Frequency, FTest, Fv, FVSchedule, Gamma, Gamma_Dist, Gamma_Inv, GammaDist, GammaInv, GammaLn, GammaLn_Precise, Gauss, Gcd, GeoMean, GeStep, Growth, HarMean, Hex2Bin, Hex2Dec, Hex2Oct, HLookup, HypGeom_Dist, HypGeomDist, IfError, IfNa, ImAbs, Imaginary, ImArgument, ImConjugate, ImCos, ImCosh, ImCot, ImCsc, ImCsch, ImDiv, ImExp, ImLn, ImLog10, ImLog2, ImPower, ImProduct, ImReal, ImSec, ImSech, ImSin, ImSinh, ImSqrt, ImSub, ImSum, ImTan, Index, Intercept, IntRate, Ipmt, Irr, IsErr, IsError, IsEven, IsFormula, IsLogical, IsNA, IsNonText, IsNumber, ISO_Ceiling, IsOdd, IsoWeekNum, Ispmt, IsText, Kurt, Large, Lcm, LinEst, Ln, Log, Log10, LogEst, LogInv, LogNorm_Dist, LogNorm_Inv, LogNormDist, Lookup, Match, Max, MDeterm, MDuration, Median, Min, MInverse, MIrr, MMult, Mode, Mode_Mult, Mode_Sngl, MRound, MultiNomial, Munit, NegBinom_Dist, NegBinomDist, NetworkDays, NetworkDays_Intl, Nominal, Norm_Dist, Norm_Inv, Norm_S_Dist, Norm_S_Inv, NormDist, NormInv, NormSDist, NormSInv, NPer, Npv, NumberValue, Oct2Bin, Oct2Dec, Oct2Hex, Odd, OddFPrice, OddFYield, OddLPrice, OddLYield, Or, PDuration, Pearson, Percentile, Percentile_Exc, Percentile_Inc, PercentRank, PercentRank_Exc, PercentRank_Inc, Permut, Permutationa, Phi, Phonetic, Pi, Pmt, Poisson, Poisson_Dist, Power, Ppmt, Price, PriceDisc, PriceMat, Prob, Product, Proper, Pv, Quartile, Quartile_Exc, Quartile_Inc, Quotient, Radians, RandBetween, Rank, Rank_Avg, Rank_Eq, Rate, Received, Replace, ReplaceB, Rept, Roman, Round, RoundDown, RoundUp, Rri, RSq, RTD, Search, SearchB, Sec, Sech, SeriesSum, Sinh, Skew, Skew_p, Sln, Slope, Small, SqrtPi, Standardize, StDev, StDev_P, StDev_S, StDevP, StEyx, Substitute, Subtotal, Sum, SumIf, SumIfs, SumProduct, SumSq, SumX2MY2, SumX2PY2, SumXMY2, Syd, T_Dist, T_Dist_2T, T_Dist_RT, T_Inv, T_Inv_2T, T_Test, Tanh, TBillEq, TBillPrice, TBillYield, TDist, Text, TInv, Transpose, Trend, Trim, TrimMean, TTest, Unichar, Unicode, USDollar, Var, Var_P, Var_S, VarP, Vdb, VLookup, WebService, Weekday, WeekNum, Weibull, Weibull_Dist, WorkDay, WorkDay_Intl, Xirr, Xnpv, Xor, YearFrac, YieldDisc, YieldMat, Z_Test, ZTest, Forecast_ETS, Forecast_ETS_ConfInt, Forecast_ETS_Seasonality, Forecast_ETS_STAT, Forecast_Linear